Template:BCS card list by introduced: Difference between revisions

mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly><div class="center-col-1 center-col-3 center-col-4">
<includeonly><div class="center-col-2 responsive-block-col-1">
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=bcs_monkeys
tables=bcs_monkeys
;fields=CONCAT("[[File:", image, "|20px|link=", _pageName, "|", name, "]]") = Art,
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] [[", _pageName, "|", name, "]]") = Card,
CONCAT("[[", _pageName, "|", name, "]]") = Name,
COALESCE(CONCAT(class, " Monkey"), "Monkey")=Type
COALESCE(CONCAT(class, " Monkey"), "Monkey")=Card type


;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
;order by=name
;order by=name
|tables=bcs_bloons
|tables=bcs_bloons
;fields=CONCAT("[[File:", image, "|20px|link=", _pageName, "|", name, "]]") = Art,
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] [[", _pageName, "|", name, "]]") = Card,
CONCAT("[[", _pageName, "|", name, "]]") = Name,
COALESCE(CONCAT(class, " Monkey"), "Monkey")=Type
COALESCE(CONCAT(class, " Bloon"), "Bloon")=Card type


;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
;order by=name
;order by=name
|tables=bcs_powers
|tables=bcs_powers
;fields=CONCAT("[[File:", image, "|20px|link=", _pageName, "|", name, "]]") = Art,
;fields=CONCAT("[[File:", image, "|30px|link=", _pageName, "|Icon of ", name, "]] [[", _pageName, "|", name, "]]") = Card,
CONCAT("[[", _pageName, "|", name, "]]") = Name,
COALESCE(CONCAT(class, " Monkey"), "Monkey")=Type
COALESCE(CONCAT(class, " Power"), "Power")=Card type


;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}