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 |
||
| 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 | |fields=Shop.name, Shop.image, GROUP_CONCAT(Shop_Item.item)=Items, Shop._pageName | ||
|where=Shop_Item.item LIKE 'sand%' | |where=Shop_Item.item LIKE '%sand%' | ||
|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:43, 17 December 2024
| name | image | Items | _pageName |
|---|---|---|---|
| BongoCat |  |
Soul Sand,Sand | Shop:S3 Bongocat |
| Coal Co |  |
Sand | Shop:S3 Coal Co |
| Deni's Sand |  |
Sand | Shop:S3 Deni'S Sand |
| Gold Casino |  |
Soul Sand | Shop:S3 Gold Casino |
| The SANDwich Shop |  |
Sand | Shop:S3 The Sandwich Shop |
| The Slab Shack |  |
Red Sand,Red Sandstone,Sandstone Slab,Sandstone Stairs,Sandstone Wall,Smooth Sandstone,Smooth Sandstone Slab,Smooth Sandstone Stairs | Shop:S3 The Slab Shack |
| Thom Company Limited (TCL) | .png) |
Sand,Sandstone,Soul Sand | Shop:S3 Thom Company Limited (Tcl) |