Template:BTD6 cosmetic item list by introduced: Difference between revisions
Pymonkibot (talk | contribs) m Text replacement - "pagename field" to "link field" |
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 | ||
|extra col 2=IF(GROUP_CONCAT(sources.name) LIKE "%Trophy Store%", "{{Y}}", "{{N}}") = Trophy Store? | {{#if:{{{show 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=Trophy Store? DESC, items.category, items.subcategory, items.name | |order by={{#if:{{{show trophy store|}}}|Trophy Store? DESC,}} items.category, items.subcategory, items.name | ||
}}</includeonly><noinclude>{{/doc}}</noinclude> | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||