Blooncyclopedia

Template:BTDB2 cosmetic item list by introduced: Difference between revisions

Newer edit →
Polavux (talk | contribs)
Bureaucrats, Interface administrators, Administrators
58,352 edits
VisualWikitext
Created page with "<includeonly><div class="center-col-1 center-col-3 center-col-5">{{#cargo_query:tables=btdb2_cosmetic_items, btdb2_cosmetic_categories |where =introduced = "{{{1|}}}" |fields=CONCAT("20px|", btdb2_cosmetic_items.name, "") = Icon, CONCAT(btdb2_cosmetic_items.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> CONCAT("File:", btdb2_cosmetic_categories.icon, "|x20px|", btdb2_cosmetic_categori..."
 
mNo edit summary
Line 1: Line 1:
<includeonly><div class="center-col-1 center-col-3 center-col-5">{{#cargo_query:tables=btdb2_cosmetic_items, btdb2_cosmetic_categories
<includeonly><div class="center-col-1 center-col-3 center-col-5">{{#cargo_query:tables=btdb2_cosmetic_items
|where =introduced = "{{{1|}}}"
|fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of", name, "]] ", name) = Item,
|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|20px|", btdb2_cosmetic_items.name, "]]") = Icon,
CONCAT("[[", _pageName, "|", category, "]]") = Category
CONCAT(btdb2_cosmetic_items.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly -->
|limit=200
CONCAT("[[File:", btdb2_cosmetic_categories.icon, "|x20px|", btdb2_cosmetic_categories.name, "|link=", btdb2_cosmetic_categories._pageName, "]][[",
btdb2_cosmetic_categories._pageName, "|", btdb2_cosmetic_categories.name, "]]") = Category


|join on =btdb2_cosmetic_items.category = btdb2_cosmetic_categories.name
|order by=category,name
|group by=btdb2_cosmetic_items.image, btdb2_cosmetic_items.name, btdb2_cosmetic_categories.icon, btdb2_cosmetic_categories._pageName, btdb2_cosmetic_categories.name, btdb2_cosmetic_items.introduced
|where  =introduced = "{{{1|}}}"
|order by=Category
}}</div></includeonly><noinclude>{{/doc}}</noinclude>
}}</div></includeonly><noinclude>{{/doc}}[[Category:Cargo query templates]][[Category:Battles 2 templates]]</noinclude>
Retrieved from "https://www.bloonswiki.com/Template:BTDB2_cosmetic_item_list_by_introduced"