Template:BCS card list by introduced: Difference between revisions

Created page with "<includeonly><div class="center-col-1 center-col-3 center-col-4"> {{#cargo_compound_query: tables=bcs_monkeys ;fields=CONCAT("20px|link=", _pageName, "|", name, "") = Art, CONCAT("", name, "") = Name, CONCAT("Monkey")=Card type, COALESCE(rarity, "—") = Rarity ;where=introduced="{{{1|2.0}}}" ;order by=name |tables=bcs_bloons ;fields=CONCAT("20px|link=", _pageName, "|", name, "") = Art, CONCAT("", _pageName..."
 
mNo edit summary
 
(13 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<includeonly><div class="center-col-1 center-col-3 center-col-4">
<includeonly>{{generic cargo compact list
{{#cargo_compound_query:
|table=bcs_cards
tables=bcs_monkeys
|col 1 name=Card
;fields=CONCAT("[[File:", image, "|20px|link=", _pageName, "|", name, "]]") = Art,
|extra col 1=class=Class
CONCAT("[[", _pageName, "|", name, "]]") = Name,
|extra col 2={{#if:{{{hide rarity|}}}||rarity=Rarity}}
CONCAT("Monkey")=Card type,
|where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{pack}}}"}}
COALESCE(rarity, "—") = Rarity
|center extra cols=y
 
|image field=IF(icon IS NOT NULL, icon, image)
;where=introduced="{{{1|2.0}}}"
|order by=name
;order by=name
}}</includeonly><noinclude>{{/doc}}</noinclude>
|tables=bcs_bloons
;fields=CONCAT("[[File:", image, "|20px|link=", _pageName, "|", name, "]]") = Art,
CONCAT("[[", _pageName, "|", name, "]]") = Name,
CONCAT("Bloon")=Card type,
COALESCE(rarity, "—") = Rarity
 
;where=introduced="{{{1|2.0}}}"
;order by=name
|tables=bcs_powers
;fields=CONCAT("[[File:", image, "|20px|link=", _pageName, "|", name, "]]") = Art,
CONCAT("[[", _pageName, "|", name, "]]") = Name,
CONCAT("Power")=Card type,
COALESCE(rarity, "—") = Rarity
 
;where=introduced="{{{1|2.0}}}"
;order by=name
|format=table
}}
</div></includeonly><noinclude>{{/doc}}</noinclude>