Template:BTD6 cosmetic item list by id: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 6: | Line 6: | ||
WHEN sources.name LIKE 'Trophy Store%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first --> | WHEN sources.name LIKE 'Trophy Store%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first --> | ||
SEPARATOR ', '), "TBD") = Unlock method(s),}} | SEPARATOR ', '), "TBD") = Unlock method(s),}} | ||
IF(items.introduced = "", "''To be added''", CONCAT("[[Bloons TD 6 v", items.introduced, "|Version ", items.introduced, "]]")) = Introduced | IF(items.introduced = "", "''To be added''", CONCAT("[[Bloons TD 6 v", items.introduced, "|Version ", items.introduced, "]]", IF(items.xd_only, " ([[Bloons TD 6 (Chinese)|Chinese version]] only)", ""))) = Introduced | ||
|where=items.id = '{{{1|}}}' OR items.id = '{{{2|}}}' OR items.id = '{{{3|}}}' OR items.id = '{{{4|}}}' OR items.id = '{{{5|}}}' OR items.id = '{{{6|}}}' OR items.id = '{{{7|}}}' OR items.id = '{{{8|}}}' OR items.id = '{{{9|}}}' OR items.id = '{{{10|}}}' OR items.id = '{{{11|}}}' OR items.id = '{{{12|}}}' OR items.id = '{{{13|}}}' OR items.id = '{{{14|}}}' OR items.id = '{{{15|}}}' OR items.id = '{{{16|}}}' OR items.id = '{{{17|}}}' OR items.id = '{{{18|}}}' OR items.id = '{{{19|}}}' OR items.id = '{{{20|}}}' | |where=items.id = '{{{1|}}}' OR items.id = '{{{2|}}}' OR items.id = '{{{3|}}}' OR items.id = '{{{4|}}}' OR items.id = '{{{5|}}}' OR items.id = '{{{6|}}}' OR items.id = '{{{7|}}}' OR items.id = '{{{8|}}}' OR items.id = '{{{9|}}}' OR items.id = '{{{10|}}}' OR items.id = '{{{11|}}}' OR items.id = '{{{12|}}}' OR items.id = '{{{13|}}}' OR items.id = '{{{14|}}}' OR items.id = '{{{15|}}}' OR items.id = '{{{16|}}}' OR items.id = '{{{17|}}}' OR items.id = '{{{18|}}}' OR items.id = '{{{19|}}}' OR items.id = '{{{20|}}}' | ||
|join on =items.id = sources.item | |join on =items.id = sources.item | ||
|group by=items._pageName, items.name, items.image, items.description, items.category, items.subcategory, items.introduced | |group by=items._pageName, items.name, items.image, items.description, items.category, items.subcategory, items.introduced, items.xd_only | ||
|order by=introduced | |order by=introduced | ||
|format =table | |format =table | ||