Template:BTD6 cosmetic item list by id: Difference between revisions
No edit summary |
mNo edit summary |
||
| Line 4: | Line 4: | ||
CONCAT(btd6_cosmetic_items.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> | CONCAT(btd6_cosmetic_items.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> | ||
CONCAT(btd6_cosmetic_items.category, " — ", "[[", btd6_cosmetic_items._pageName, "|", btd6_cosmetic_items.subcategory, "]]") = Category, | CONCAT(btd6_cosmetic_items.category, " — ", "[[", btd6_cosmetic_items._pageName, "|", btd6_cosmetic_items.subcategory, "]]") = Category, | ||
GROUP_CONCAT(btd6_cosmetic_sources.name ORDER BY CASE | COALESCE(GROUP_CONCAT(btd6_cosmetic_sources.name ORDER BY CASE | ||
WHEN btd6_cosmetic_sources.name LIKE 'Trophy Store%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first --> | WHEN btd6_cosmetic_sources.name LIKE 'Trophy Store%' THEN 0 ELSE 1 END <!-- sources beginning with "Trophy Store" are listed first --> | ||
SEPARATOR ', ') = Source(s), | SEPARATOR ', '), "TBD") = Source(s), | ||
CONCAT("[[Bloons TD 6 v", btd6_cosmetic_items.introduced, "|Version ", btd6_cosmetic_items.introduced, "]]") = Introduced | IF(btd6_cosmetic_items.introduced IS NULL, "TBD", CONCAT("[[Bloons TD 6 v", btd6_cosmetic_items.introduced, "|Version ", btd6_cosmetic_items.introduced, "]]")) = Introduced | ||
|where ={{#invoke:cargo name list|main|id|{{{1|x}}}}} | |where ={{#invoke:cargo name list|main|id|{{{1|x}}}}} | ||