Template:BCS card list by introduced: Difference between revisions

No edit summary
simplified a bit
Line 1: Line 1:
<includeonly><div class="center-col-2 responsive-block-col-1">
<includeonly><div class="center-col-2 responsive-block-col-1">{{#cargo_query:table=bcs_cards
{{#cargo_compound_query:
|fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] [[", _pageName, "|", name, "]]") = Card,
tables=bcs_monkeys
class=Class
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] [[", _pageName, "|", name, "]]") = Card,
|where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
COALESCE(CONCAT(class, " Monkey"), "Monkey")=Type
|order by=name
 
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
;order by=name
|tables=bcs_bloons
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] [[", _pageName, "|", name, "]]") = Card,
COALESCE(CONCAT(class, " Bloon"), "Bloon")=Type
 
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
;order by=name
|tables=bcs_powers
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] [[", _pageName, "|", name, "]]") = Card,
COALESCE(CONCAT(class, " Power"), "Power")=Type
 
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
;order by=name
|format=table
}}
}}
</div></includeonly><noinclude>{{/doc}}</noinclude>
</div></includeonly><noinclude>{{/doc}}</noinclude>