Template:Shop Item Query: Difference between revisions

Revision as of 18:04, 18 December 2024

name	image	Items	_pageName
BongoCat	S3 Shop bongocat.png	Soul Sand(672, 29),Sand(672, 29)	Shop:S3 Bongocat
Coal Co	S3 Shop coal co.png	Sand(683, -39)	Shop:S3 Coal Co
Deni's Sand	S3 Shop denis sand.png	Sand(843, -41)	Shop:S3 Deni'S Sand
Gold Casino	S3 Shop gold casino.png	Soul Sand(777, 52)	Shop:S3 Gold Casino
The SANDwich Shop	S3 Shop the sandwich shop.png	Sand(839, 84)	Shop:S3 The Sandwich Shop
The Slab Shack	S3 Shop the slab shack.png	Red Sand(791, -2),Red Sandstone(791, -2),Sandstone Slab(791, -2),Sandstone Stairs(791, -2),Sandstone Wall(791, -2),Smooth Sandstone(791, -2),Smooth Sandstone Slab(791, -2),Smooth Sandstone Stairs(791, -2)	Shop:S3 The Slab Shack
Thom Company Limited (TCL)	S3 Shop thom company limited (tcl).png	Sand(770, 119),Sandstone(770, 119),Soul Sand(770, 119)	Shop:S3 Thom Company Limited (Tcl)

@@ Line 1: / Line 1: @@
 {{#cargo_query:
 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, ')')=Items, Shop._pageName
-|where=Shop_Item.item LIKE '%sand%'
+|where=Shop_Item.item LIKE '%sand%' AND Shop.season="SurvivalS3"
 |join on=Shop._pageName = Shop_Item._pageName
 |group by=Shop.name, Shop.image, Shop._pageName
 }}