More actions
GamingTwist (talk | contribs) Created page with "{{#cargo_query: tables=Shop, Shop_Item |fields=Shop.name, Shop.image, GROUP_CONCAT(Shop_Item.item, ',')=Items, Shop._pageName |where=Shop_Item.item LIKE 'sand%' |join on=Shop._pageName = Shop_Item._pageName |group by=Shop.name, Shop.image, Shop._pageName }}" |
GamingTwist (talk | contribs) No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| 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, ',')=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 | ||
}} | }} | ||
Latest revision as of 17:37, 19 December 2024
No results