Template:BTD6 cosmetic item list by introduced: Difference between revisions
column noting if an item is in the trophy store or not |
mNo edit summary |
||
| Line 3: | Line 3: | ||
CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category, | CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category, | ||
IF(GROUP_CONCAT(sources.name) LIKE "%Trophy Store%", "{{Y}}", "{{N}}") = Trophy Store? | IF(GROUP_CONCAT(sources.name) LIKE "%Trophy Store%", "{{Y}}", "{{N}}") = Trophy Store? | ||
|where=items.introduced = "{{{1|}}}" | |where=items.introduced = "{{{1|}}}" {{#if:{{{xd only|}}}|AND xd_only|AND NOT xd_only}} | ||
|join on =items.id = sources.item | |join on =items.id = sources.item | ||