More actions
GamingTwist (talk | contribs) No edit summary |
GamingTwist (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
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, ')')=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 ' | |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 | ||
}} | }} | ||
Revision as of 18:15, 18 December 2024
No results