More actions
GamingTwist (talk | contribs) No edit summary |
GamingTwist (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
tables=Shop, Shop_Item | tables=Shop, Shop_Item | ||
|fields=Shop.name, Shop.image, GROUP_CONCAT(Shop_Item.item, ' ( ', Shop_Item.world_x, ', ', Shop_Item.world_z, ' )' SEPARATOR ';')=Items, Shop._pageName | |fields=Shop.name, Shop.image, GROUP_CONCAT(Shop_Item.item, ' ( ', Shop_Item.world_x, ', ', Shop_Item.world_z, ' )' SEPARATOR ';')=Items, Shop._pageName | ||
|where=Shop_Item.item LIKE '{{{item}}}' AND Shop.season="{{{season|}}}" | |where=Shop_Item.item LIKE '%{{{item}}}%' AND Shop.season="{{{season|}}}" | ||
|join on=Shop._pageName = Shop_Item._pageName | |join on=Shop._pageName = Shop_Item._pageName | ||
|group by=Shop.name, Shop.image, Shop._pageName | |group by=Shop.name, Shop.image, Shop._pageName | ||
}} | }} | ||
Latest revision as of 17:37, 19 December 2024
No results