Template:BTD6 cosmetic item list by introduced: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| 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:{{{ | {{#if:{{{hide trophy store|}}}||{{!}}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 11: | ||
|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={{#if:{{{ | |order by={{#if:{{{hide trophy store|}}}||Trophy Store? DESC,}} items.category, items.subcategory, items.name | ||
}}</includeonly><noinclude>{{/doc}}</noinclude> | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||