Template:BTD6 cosmetic item list by introduced: Difference between revisions
mNo edit summary |
column noting if an item is in the trophy store or not |
||
| Line 1: | Line 1: | ||
<includeonly><div class="center-col-2"> | <includeonly><div class="center-col-2 center-col-3">{{#cargo_query:table=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources | ||
{{#cargo_query:table=btd6_cosmetic_items | |fields=CONCAT("[[File:", items.image, "|30px|link=", items._pageName, "|Icon of", items.name, "]] ", items.name) = Name, | ||
|fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of", name, "]] ", name) = Name, | CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category, | ||
CONCAT(category, " ― [[", _pageName, "|", subcategory, "]]") = Category | IF(GROUP_CONCAT(sources.name) LIKE "%Trophy Store%", "{{Y}}", "{{N}}") = Trophy Store? | ||
|where=introduced = "{{{1|}}}" | |where=items.introduced = "{{{1|}}}" | ||
|join on =items.id = sources.item | |||
|group by=items._pageName, items.name, items.image, items.category, items.subcategory, items.introduced | |||
|format=table | |format=table | ||
|order by=category, subcategory, name | |order by=Trophy Store?, items.category, items.subcategory, items.name | ||
}}</div></includeonly><noinclude>{{/doc}}</noinclude> | }}</div></includeonly><noinclude>{{/doc}}</noinclude> | ||