Template:BTD6 cosmetic item list by introduced: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{generic cargo compact list|tables=btd6_cosmetic_items=items | <includeonly>{{#if:{{{hide trophy store|}}}|{{generic cargo compact list|tables=btd6_cosmetic_items=items | ||
|image field=items.image | |image field=items.image | ||
|link field=CONCAT(items._pageName, "#", items.name) | |link field=CONCAT(items._pageName, "#", items.name) | ||
| Line 5: | Line 5: | ||
|extra col 1=CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category | |extra col 1=CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category | ||
{{#if:{{{ | |center extra cols=y | ||
|where=items.introduced = "{{{1|}}}" {{#if:{{{xd only|}}}|AND xd_only|AND NOT xd_only}} | |||
|order by=items.category, items.subcategory, items.name | |||
}}|{{generic cargo compact list|tables=btd6_cosmetic_items=items, btd6_cosmetic_sources=sources | |||
|image field=items.image | |||
|link field=CONCAT(items._pageName, "#", items.name) | |||
|name field=items.name | |||
|extra col 1=CONCAT(items.category, " ― [[", items._pageName, "|", items.subcategory, "]]") = Category | |||
|extra col 2=IF(GROUP_CONCAT(sources.name) LIKE "%Trophy Store%", "{{Y}}", "{{N}}") = Trophy Store? | |||
|center extra cols=y | |center extra cols=y | ||
| Line 11: | Line 21: | ||
|join on =items.id = sources.item | |join on =items.id = sources.item | ||
|group by=items._pageName, items.name, items.image, items.category, items.subcategory, items.introduced | |group by=items._pageName, items.name, items.image, items.category, items.subcategory, items.introduced | ||
|order by= | |order by=Trophy Store? DESC, items.category, items.subcategory, items.name | ||
}}</includeonly><noinclude>{{/doc}}</noinclude> | }}}}</includeonly><noinclude>{{/doc}}</noinclude> | ||