Template:BCS cosmetic item list by hero: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 5: | Line 5: | ||
CONCAT(CASE WHEN items.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Bloons Card Storm v", items.introduced, "|Version ", items.introduced, "]]") END) = Introduced | CONCAT(CASE WHEN items.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Bloons Card Storm v", items.introduced, "|Version ", items.introduced, "]]") END) = Introduced | ||
|where = | |where =items.applies_to HOLDS "{{{1|}}}" | ||
|join on =items.id = rewards.item | |join on =items.id = rewards.item | ||
|group by=items._pageName, items.name, items.image, items.introduced, rewards.item | |group by=items._pageName, items.name, items.image, items.introduced, rewards.item | ||