Template:BCS card list by introduced: Difference between revisions

mNo edit summary
mNo edit summary
Line 6: Line 6:
COALESCE(CONCAT(class, " Monkey"), "Monkey")=Card type
COALESCE(CONCAT(class, " Monkey"), "Monkey")=Card type


;where=introduced="{{{1|2.0}}}"
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{2}}}"}}
;order by=name
;order by=name
|tables=bcs_bloons
|tables=bcs_bloons
Line 13: Line 13:
COALESCE(CONCAT(class, " Bloon"), "Bloon")=Card type
COALESCE(CONCAT(class, " Bloon"), "Bloon")=Card type


;where=introduced="{{{1|2.0}}}"
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{2}}}"}}
;order by=name
;order by=name
|tables=bcs_powers
|tables=bcs_powers
Line 20: Line 20:
COALESCE(CONCAT(class, " Power"), "Power")=Card type
COALESCE(CONCAT(class, " Power"), "Power")=Card type


;where=introduced="{{{1|2.0}}}"
;where=introduced="{{{1|2.0}}}"{{#if:{{{pack|}}}|AND pack="{{{2}}}"}}
;order by=name
;order by=name
|format=table
|format=table
}}
}}
</div></includeonly><noinclude>{{/doc}}</noinclude>
</div></includeonly><noinclude>{{/doc}}</noinclude>