Template:BTD6 cosmetic item list by id: Difference between revisions

mNo edit summary
mNo edit summary
Line 4: Line 4:
CONCAT(items.category, " — ", "[[", items._pageName, "|", items.subcategory, "]]") = Category,
CONCAT(items.category, " — ", "[[", items._pageName, "|", items.subcategory, "]]") = Category,
{{#if:{{{hide sources|}}}||COALESCE(GROUP_CONCAT(sources.name ORDER BY CASE
{{#if:{{{hide sources|}}}||COALESCE(GROUP_CONCAT(sources.name ORDER BY CASE
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, "]]", IF(items.xd_only, " ([[Bloons TD 6 (Chinese)|Chinese version]] only)", ""))) = 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