Card query

<noinclude>This template is an alternate version of {{t|List cards}} with tons of new supports and different use of parameters.

==Usage==
<pre>{{Card query
 |layout=
 |where=
 |orderBy=
 |collapsed=
 |limit=
 |offset=
}}</pre>

==Parameters==
*<code>layout</code>: Choose one of these layouts: table, image, or count. Default is table.
*<code>where</code>: Where clauses, pretty much like SQL functions.
*<code>orderBy</code>: Order to sort the results. Default is <code>Cards.cost ASC, Cards.name ASC</code>.
*<code>collapsed</code>: If true (default), the table/card image list will be collapsed after the page is reloaded, and vice versa if false.
*<code>limit</code>: Maximum number of cards to display. If the limit number and the results number are too high, it will display error: "The time allocated for running scripts has expired." Default is 500
*<code>offset</code>: the number of initial cards to skip. This combines with <code>limit</code> for separating lists whose the number of results are very high into individual pages/articles.
===Where clauses===

==Examples==
</noinclude><includeonly>{{#vardefine:count|0}}{{<!--TEMPLATE NAME-->{{#switch:{{lc:{{{layout}}}}}|gallery=Gallery|#default=Count layout}}|widths={{{width|300}}}|heights={{{width|300}}}|{{#trim:{{#invoke:Cargo|query|tables=Cards, _pageData, CustomCardsCardSet, CardsCardClass, CardsCardType, CardsRace, CardsSpellSchool, CardsRarity, CardsMultiClassGroup
 |join=Cards._pageId=_pageData._pageId, Cards.setsId=CustomCardsCardSet.id, Cards.classesId__full=CardsCardClass.id, Cards.typeId=CardsCardType.id, Cards.raceId=CardsRace.id, Cards.spellSchoolId=CardsSpellSchool.id, Cards.rarityId=CardsRarity.id, Cards.multiclassGroupId=CardsMultiClassGroup.id
 |fields={{#switch:{{lc:{{{layout|}}}}}
  |#default={{Cards tb|cost}}=cost, Cards.name=name, Cards.dbfId=dbfId, Cards.id=id, Cards._pageName=link, Cards.classes__full=classes, {{Cards tb|type}}=type, {{Cards tb|race}}=race, {{Cards tb|spellSchool}}=spellSchool, {{Cards tb|rarity}}=rarity, {{Cards tb|attack}}=attack, {{Cards tb|health}}=health, {{Cards tb|durability}}=durability, {{Cards tb|armor}}=armor, {{Cards tb|text}}=text, {{Cards tb|{{#switch:{{lc:{{{layout|}}}}}|#default=image|bg image|image battlegrounds=bg_image|image golden|golden no inout=gold_image|image diamond=diamond_image}}}}=image, Cards.bg_image=image2, {{Cards tb|costs_gold}}=costs_gold, Cards.customFullArt=customFullArt, Cards.heroPowerDbfId=heroPowerDbfId, Cards.customRelatedCardsDbfId__full=customRelatedCardsDbfId, Cards.customChoiceCardsDbfId__full=customChoiceCardsDbfId {{#if:{{{footer|}}}|,CONCAT({{{footer}}})=footer}} {{#if:{{{width|}}}|,CONCAT("{{{width|}}}")=width}}, CONCAT("{{#switch:{{lc:{{{layout|}}}}}
   |table minion=durability, armor
   |table spell|table hero power=attack, health, durability, armor
   |table weapon=health, armor
   |table hero=attack, durability
   |#default={{{hides|}}}
  }}")=hides
  |count=COUNT(*)=count
 }}
 |where={{#switch:{{{format|}}}
  |=
  |#default=({{#lstmap:{{All sets id|{{{format}}}|}}|&&|@@@@|Cards.setsId="@@@@"|\_OR\_}}) AND
 }} {{#if:{{{where|}}}|{{{where}}}|{{#lstmap:<!--

  -->{{#switch:{{lc:{{{collectible|{{#ifeq:{{NAMESPACE}}|Special||1}} }}} }}|#default=(Cards._pageName IS NOT NULL)!!|1|yes|true=(Cards.collectible="1")!!|0|no|false=(Cards.collectible="0" OR Cards.collectible IS NULL)!!}}<!--

  -->{{#if:{{{pageName|}}}|({{#lstmap:{{{pageName}}}|&&|@@@@|Cards._pageName="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{name|}}}|({{#lstmap:{{{name}}}|&&|@@@@|Cards.name LIKE "%@@@@%"|\_AND\_}})!!}}<!--
  -->{{#if:{{{dbfId|}}}|({{#lstmap:{{{dbfId}}}|&&|@@@@|Cards.dbfId="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{dbfIdNot|}}}|NOT ({{#lstmap:{{{dbfIdNot}}}|&&|@@@@|Cards.dbfId="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{id|}}}|({{#lstmap:{{{id}}}|&&|@@@@|Cards.id="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{text|}}}|({{#lstmap:{{{text}}}|&&|@@@@|Cards.customRenderedText LIKE "%@@@@%"|{{#switch:{{lc:{{{textAdvanced}}}}}|#default=\_OR\_|1|yes|true|and=\_AND\_}}}})!!}}<!--

  -->{{#if:{{{cost|}}}|({{#lstmap:{{{cost|}}}|,|@@@@|Cards.cost="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{costNot|}}}|NOT ({{#lstmap:{{{costNot|}}}|,|@@@@|Cards.cost="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{costMore|}}}|(Cards.cost>={{{costMore|}}})!!}}<!--
  -->{{#if:{{{costLess|}}}|(Cards.cost<={{{costLess|}}})!!}}<!--

  -->{{#switch:{{lc:{{{costOdd}}}}}|1|yes|true=({{#lstmap:1,3,5,7,9,11,13,15,25|,|@@@@|Cards.cost="@@@@"|\_OR\_}})}}<!--
  -->{{#switch:{{lc:{{{costEven}}}}}|1|yes|true=({{#lstmap:0,2,4,6,8,10,12,14,20,50|,|@@@@|Cards.cost="@@@@"|\_OR\_}})}}<!--

  -->{{#if:{{{attack|}}}|({{#lstmap:{{{attack|}}}|,|@@@@|Cards.attack="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{attackNot|}}}|NOT ({{#lstmap:{{{attackNot|}}}|,|@@@@|Cards.attack="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{attackMore|}}}|(Cards.attack>={{{attackMore|}}})!!}}<!--
  -->{{#if:{{{attackLess|}}}|(Cards.attack<={{{attackLess|}}})!!}}<!--

  -->{{#if:{{{health|}}}|({{#lstmap:{{{health|}}}|,|@@@@|Cards.health="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{healthNot|}}}|NOT ({{#lstmap:{{{healthNot|}}}|,|@@@@|Cards.health="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{healthMore|}}}|(Cards.health>={{{healthMore|}}})!!}}<!--
  -->{{#if:{{{healthLess|}}}|(Cards.health<={{{healthLess|}}})!!}}<!--

  -->{{#if:{{{dura|}}}|({{#lstmap:{{{dura|}}}|,|@@@@|Cards.durability="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{duraNot|}}}|NOT ({{#lstmap:{{{duraNot|}}}|,|@@@@|Cards.durability="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{duraMore|}}}|(Cards.durability>={{{duraMore|}}})!!}}<!--
  -->{{#if:{{{duraLess|}}}|(Cards.durability<={{{duraLess|}}})!!}}<!--

  -->{{#if:{{{armor|}}}|({{#lstmap:{{{armor|}}}|,|@@@@|Cards.armor="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{armorNot|}}}|NOT ({{#lstmap:{{{armorNot|}}}|,|@@@@|Cards.armor="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{armorMore|}}}|(Cards.armor>={{{armorMore|}}})!!}}<!--
  -->{{#if:{{{armorLess|}}}|(Cards.armor<={{{armorLess|}}})!!}}<!--

  -->{{#if:{{{costVSattack|}}}|(Cards.cost{{{costVSattack}}}Cards.attack)!!}}<!--
  -->{{#if:{{{costVShealth|}}}|(Cards.cost{{{costVShealth}}}Cards.health)!!}}<!--
  -->{{#if:{{{costVSdura|}}}|(Cards.cost{{{costVSdura}}}Cards.durability)!!}}<!--
  -->{{#if:{{{attackVShealth|}}}|(Cards.attack{{{attackVShealth}}}Cards.health)!!}}<!--
  -->{{#if:{{{attackVSdura|}}}|(Cards.attack{{{attackVSdura}}}Cards.durability)!!}}<!--

  -->{{#if:{{{sets|}}}|({{#lstmap:{{{sets}}}|,|@@@@|CustomCardsCardSet.promotionName="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{setsNot|}}}|({{#lstmap:{{{setsNot}}}|,|@@@@|NOT CustomCardsCardSet.promotionName="@@@@"|\_AND\_}})!!}}<!--
  -->{{#if:{{{core|}}}|({{#lstmap:{{{core}}}|,|@@@@|Cards.customIs_Core@@@@=1|\_OR\_}})!!}}<!--

  -->{{#if:{{{classes|}}}|({{#lstmap:{{{classes}}}|,|@@@@|<esc>{{Holds2|Cards.classes|@@@@|,}}</esc>|{{#switch:{{lc:{{{classesAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{classesNot|}}}|({{#lstmap:{{{classesNot}}}|,|@@@@|(NOT <esc>{{Holds2|Cards.classes|@@@@|,}}</esc>)|\_AND\_}})!!}}<!--

  -->{{#if:{{{multiClassGroups|}}}|({{#lstmap:{{{multiClassGroups}}}|,|@@@@|CardsMultiClassGroup.renderName="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{multiClassGroupsNot|}}}|({{#lstmap:{{{multiClassGroupsNot}}}|,|@@@@|NOT CardsMultiClassGroup.renderName="@@@@"|\_AND\_}})!!}}<!--

  -->{{#if:{{{types|}}}|({{#lstmap:{{{types}}}|,|@@@@|CardsCardType.renderName="@@@@"|\_OR\_}})!!}}<!--
  -->{{#if:{{{typesNot|}}}|({{#lstmap:{{{typesNot}}}|,|@@@@|NOT CardsCardType.renderName="@@@@"|\_AND\_}})!!}}<!--

  -->{{#if:{{{races|}}}|({{#lstmap:{{{races}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.raceId IS NULL|CardsRace.renderName="@@@@"}}</esc>|\_OR\_}})!!}}<!--
  -->{{#if:{{{racesNot|}}}|({{#lstmap:{{{racesNot}}}|,|@@@@|NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.raceId IS NULL|CardsRace.renderName="@@@@"}}</esc>|\_AND\_}})!!}}<!--

  -->{{#if:{{{spellSchools|}}}|({{#lstmap:{{{spellSchools}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.spellSchoolId IS NULL|CardsSpellSchool.renderName="@@@@"}}</esc>|\_OR\_}})!!}}<!--
  -->{{#if:{{{spellSchoolsNot|}}}|({{#lstmap:{{{spellSchoolsNot}}}|,|@@@@|NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.spellSchoolId IS NULL|CardsSpellSchool.renderName="@@@@"}}</esc>|\_AND\_}})!!}}<!--

  -->{{#if:{{{rarities|}}}|({{#lstmap:{{{rarities}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.rarityId IS NULL|CardsRarity.renderName="@@@@"}}</esc>|\_OR\_}})!!}}<!--
  -->{{#if:{{{raritiesNot|}}}|({{#lstmap:{{{raritiesNot}}}|,|@@@@|NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.rarityId IS NULL|CardsRarity.renderName="@@@@"}}</esc>|\_AND\_}})!!}}<!--

  -->{{#if:{{{artists|}}}|({{#lstmap:{{{artists}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.artist IS NULL|Cards.artist="@@@@"}}</esc>|\_OR\_}})!!}}<!--
  -->{{#if:{{{artistsNot|}}}|({{#lstmap:{{{artistsNot}}}|,|@@@@|NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.artist IS NULL|Cards.artist="@@@@"}}</esc>|\_AND\_}})!!}}<!--

  -->{{#if:{{{voiceActors|}}}|({{#lstmap:{{{voiceActors}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.voice_actor IS NULL|Cards.voice_actor="@@@@"}}</esc>|\_OR\_}})!!}}<!--
  -->{{#if:{{{voiceActorsNot|}}}|({{#lstmap:{{{voiceActorsNot}}}|,|@@@@|NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.voice_actor IS NULL|Cards.voice_actor="@@@@"}}</esc>|\_AND\_}})!!}}<!--

  -->{{#if:{{{keywordTags|}}}|({{#lstmap:{{{keywordTags}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.keywordTags__full IS NULL|{{Holds2|Cards.keywordTags|@@@@|,}}}}</esc>|{{#switch:{{lc:{{{keywordTagsAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{keywordTagsNot|}}}|({{#lstmap:{{{keywordTagsNot}}}|,|@@@@|(NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.keywordTags__full IS NULL|{{Holds2|Cards.keywordTags|@@@@|,}}}}</esc>)|\_AND\_}})!!}}<!--

  -->{{#if:{{{referencedTags|}}}|({{#lstmap:{{{referencedTags}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.referencedTags__full IS NULL|{{Holds2|Cards.referencedTags|@@@@|,}}}}</esc>|{{#switch:{{lc:{{{referencedTagsAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{referencedTagsNot|}}}|({{#lstmap:{{{referencedTagsNot}}}|,|@@@@|(NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.referencedTags__full IS NULL|{{Holds2|Cards.referencedTags|@@@@|,}}}}</esc>)|\_AND\_}})!!}}<!--

  -->{{#if:{{{booleanTags|}}}|({{#lstmap:{{{booleanTags}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.booleanTags__full IS NULL|{{Holds2|Cards.booleanTags|@@@@|,}}}}</esc>|{{#switch:{{lc:{{{booleanTagsAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{booleanTagsNot|}}}|({{#lstmap:{{{booleanTagsNot}}}|,|@@@@|(NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.booleanTags__full IS NULL|{{Holds2|Cards.booleanTags|@@@@|,}}}}</esc>)|\_AND\_}})!!}}<!--

  -->{{#if:{{{customTags|}}}|({{#lstmap:{{{customTags}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customTags__full IS NULL|{{Holds2|Cards.customTags|@@@@|, }}}}</esc>|{{#switch:{{lc:{{{customTagsAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{customTagsNot|}}}|({{#lstmap:{{{customTagsNot}}}|,|@@@@|(NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customTags__full IS NULL|{{Holds2|Cards.customTags|@@@@|, }}}}</esc>)|\_AND\_}})!!}}<!--

  -->{{#if:{{{customReferencedTags|}}}|({{#lstmap:{{{customReferencedTags}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customReferencedTags__full IS NULL|{{Holds2|Cards.customReferencedTags|@@@@|, }}}}</esc>|{{#switch:{{lc:{{{customReferencedTagsAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{customReferencedTagsNot|}}}|({{#lstmap:{{{customReferencedTagsNot}}}|,|@@@@|(NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customReferencedTags__full IS NULL|{{Holds2|Cards.customReferencedTags|@@@@|, }}}}</esc>)|\_AND\_}})!!}}<!--

  -->{{#if:{{{customHiddenTags|}}}|({{#lstmap:{{{customHiddenTags}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customHiddenTags__full IS NULL|{{Holds2|Cards.customHiddenTags|@@@@|, }}}}</esc>|{{#switch:{{lc:{{{customHiddenTagsAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{customHiddenTagsNot|}}}|({{#lstmap:{{{customHiddenTagsNot}}}|,|@@@@|(NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customHiddenTags__full IS NULL|{{Holds2|Cards.customHiddenTags|@@@@|, }}}}</esc>)|\_AND\_}})!!}}<!--

  -->{{#if:{{{customCycles|}}}|({{#lstmap:{{{customCycles}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customCycles__full IS NULL|{{Holds2|Cards.customCycles|@@@@|, }}}}</esc>|{{#switch:{{lc:{{{customCyclesAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{customCyclesNot|}}}|({{#lstmap:{{{customCyclesNot}}}|,|@@@@|(NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customCycles__full IS NULL|{{Holds2|Cards.customCycles|@@@@|, }}}}</esc>)|\_AND\_}})!!}}<!--

  -->{{#if:{{{customExclusions|}}}|({{#lstmap:{{{customExclusions}}}|,|@@@@|<esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customExclusions__full IS NULL|{{Holds2|Cards.customExclusions|@@@@|, }}}}</esc>|{{#switch:{{lc:{{{customExclusionsAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!}}<!--
  -->{{#if:{{{customExclusionsNot|}}}|({{#lstmap:{{{customExclusionsNot}}}|,|@@@@|(NOT <esc>{{#ifeq:{{lc:@@@@}}|null|Cards.customExclusions__full IS NULL|{{Holds2|Cards.customExclusions|@@@@|, }}}}</esc>)|\_AND\_}}){{#if:{{{customExclusions|}}}|| OR Cards.customExclusions__full IS NULL}})!!}}<!--

  -->{{#if:{{{categories|}}}|({{#lstmap:{{#replace:{{{categories}}}|<nowiki> </nowiki>|_}}|,|@@@@|<esc>{{Holds2|_pageData._categories|@@@@|{{!}}}}</esc>|{{#switch:{{lc:{{{categoriesAll}}}}}|1|yes|true=\_AND\_|\_OR\_}}}})!!|(NOT _pageData._categories__full LIKE "%Removed_cards%" AND NOT _pageData._categories__full LIKE "%Boss_cards%" AND NOT _pageData._categories__full LIKE "%Unused_cards%")!!}}<!--
  -->{{#if:{{{categoriesNot|}}}|NOT ({{#lstmap:{{#replace:{{{categoriesNot}}}|<nowiki> </nowiki>|_}}|,|@@@@|<esc>{{Holds2|_pageData._categories|@@@@|{{!}}}}</esc>|\_AND\_}})!!}}<!--

 -->|!!|$$$$|$$$$|\_AND\_}}}}
 |groupBy=
 |orderBy={{#if:{{{orderBy|}}}|{{{orderBy}}}|{{#if:{{{sorts|}}}|{{{sorts}}}|Cards.cost ASC, Cards.name ASC}}}}
 |format=template
 |template={{#switch:{{lc:{{{layout|}}}}}
  |#default=List cards v2/layout
  |image|bg image|image battlegrounds|image golden|image diamond|article image|image no inout|golden no inout=Card layout
  |count=Count layout
  |dbfid=DbfId layout
  |relatedcards=Related cards layout
  |choicecards=Choice cards layout
  |gallery=Gallery layout
 }}
 |limit={{#switch:{{lc:{{{layout|}}}}}
  |#default={{{limit|500}}}
  |count=1
 }}
 |offset={{{offset|}}}
 |intro={{{intro|}}}{{#switch:{{lc:{{{layout|}}}}}
  |#default=<table class="wikitable mw-collapsible {{#switch:{{lc:{{{collapsed}}}}}|#default=mw-collapsed|0|no|n|false=}} sortable" width="100%"><tr><!--
   --><th>Name</th><!--
   --><th>Class</th><!--
   --><th>Type</th><!--
   --><th>Rarity</th><!--
   --><th>Cost</th><!--
   -->{{#switch:{{lc:{{{layout|}}}}}|#default=<th>Atk</th>|table spell|table hero power|table hero=}}<!--
   -->{{#switch:{{lc:{{{layout|}}}}}|#default=<th>HP/Dur.</th>|table minion|table hero=<th>HP</th>|table spell|table hero power=|table weapon=<th>Dur.</th>}}<!--
   -->{{#switch:{{lc:{{{layout|}}}}}|#default=<th>Armor</th>|table minion|table spell|table hero power|table weapon=}}<!--
   --><th>Description</th></tr>
  |image|bg image|image battlegrounds|image golden|image diamond=<table width="100%" class="mw-collapsible {{#switch:{{lc:{{{collapsed}}}}}|1|yes|true=mw-collapsed|#default=}}"><caption><b><big>{{{title|}}}</big></b><br/><i class="mobileonly">Swipe left or right to see the cards.</i></caption><tr><td class="mw-collapsible-content" style="text-align:center"><div class="list-cards">
  |article image=<div class="list-cards">
  |image no inout|golden no inout=
  |dbfid|relatedcards|choicecards|count=
  |gallery=
 }}
 |outro={{#switch:{{lc:{{{layout|}}}}}
  |#default=</table>{{#ifeq:{{NAMESPACE}}|Special|<center><b>Results from {{{offset|0}}} to {{#expr:{{{offset|0}}} + {{#var:count}}}}</b></center>}}
  |image|bg image|image battlegrounds|image golden|image diamond=</div></td></tr></table>{{#ifeq:{{NAMESPACE}}|Special|<center><b>Results from {{{offset|0}}} to {{#expr:{{{offset|0}}} + {{#var:count}}}}</b></center>}}
  |article image=</div>
  |image no inout|golden no inout=
  |dbfid|relatedcards|choicecards|count=
  |gallery=
 }}{{{outro|}}}
 |default={{#switch:{{lc:{{{layout|}}}}}
  |#default={{{default|'''Card not found.'''}}}
  |dbfid|relatedcards|choicecards=Cards.dbfId IS NOT NULL
 }}
}}}}}}<!--

-->{{Query buttons back next|form=Card|template=CQ|layout={{{layout|}}}|title={{{title|}}}|originalPage={{{originalPage|}}}|format={{{format|}}}|collectible={{{collectible|}}}|name={{{name|}}}|dbfId={{{dbfId|}}}|dbfIdNot={{{dbfIdNot|}}}|id={{{id|}}}|text={{{text|}}}|textAdvanced={{{textAdvanced|}}}|cost={{{cost|}}}|costNot={{{costNot|}}}|costMore={{{costMore|}}}|costLess={{{costLess|}}}|costOdd={{{costOdd|}}}|costEven={{{costEven|}}}|attack={{{attack|}}}|attackNot={{{attackNot|}}}|attackMore={{{attackMore|}}}|attackLess={{{attackLess|}}}|health={{{health|}}}|healthNot={{{healthNot|}}}|healthMore={{{healthMore|}}}|healthLess={{{healthLess|}}}|dura={{{dura|}}}|duraNot={{{duraNot|}}}|duraMore={{{duraMore|}}}|duraLess={{{duraLess|}}}|armor={{{armor|}}}|armorNot={{{armorNot|}}}|armorMore={{{armorMore|}}}|armorLess={{{armorLess|}}}|costVSattack={{{costVSattack|}}}|costVShealth={{{costVShealth|}}}|costVSdura={{{costVSdura|}}}|attackVShealth={{{attackVShealth|}}}|attackVSdura={{{attackVSdura|}}}|sets={{{sets|}}}|setsNot={{{setsNot|}}}|classes={{{classes|}}}|classesNot={{{classesNot|}}}|classesIncludeAll={{{classesIncludeAll|}}}|multiClassGroups={{{multiClassGroups|}}}|multiClassGroupsNot={{{multiClassGroupsNot|}}}|types={{{types|}}}|typesNot={{{typesNot|}}}|races={{{races|}}}|racesNot={{{racesNot|}}}|spellSchools={{{spellSchools|}}}|spellSchoolsNot={{{spellSchoolsNot|}}}|artists={{{artists|}}}|artistsNot={{{artistsNot|}}}|voiceActors={{{voiceActors|}}}|voiceActorsNot={{{voiceActorsNot|}}}|rarities={{{rarities|}}}|raritiesNot={{{raritiesNot|}}}|keywordTags={{{keywordTags|}}}|keywordTagsNot={{{keywordTagsNot|}}}|keywordTagsAll={{{keywordTagsAll|}}}|referencedTags={{{referencedTags|}}}|referencedTagsNot={{{referencedTagsNot|}}}|referencedTagsAll={{{referencedTagsAll|}}}|booleanTags={{{booleanTags|}}}|booleanTagsNot={{{booleanTagsNot|}}}|booleanTagsAll={{{booleanTagsAll|}}}|customTags={{{customTags|}}}|customTagsNot={{{customTagsAll|}}}|customTagsAll={{{customTagsAll|}}}|customReferencedTags={{{customReferencedTags|}}}|customReferencedTagsNot={{{customReferencedTagsNot|}}}|customReferencedTagsAll={{{customReferencedTagsAll|}}}|customHiddenTags={{{customHiddenTags|}}}|customHiddenTagsNot={{{customHiddenTagsNot|}}}|customHiddenTagsAll={{{customHiddenTagsAll|}}}|customCycles={{{customCycles|}}}|customCyclesNot={{{customCyclesNot|}}}|customCyclesAll={{{customCyclesAll|}}}|customExclusions={{{customExclusions|}}}|customExclusionsNot={{{customExclusionsNot|}}}|customExclusionsAll={{{customExclusionsAll|}}}|categories={{{categories|}}}|categoriesNot={{{categoriesNot|}}}|categoriesAll={{{categoriesAll|}}}|orderBy={{{orderBy|}}}|sorts={{{sorts|}}}|shows={{{shows|}}}|shows2={{{shows2|}}}|shows3={{{shows3|}}}|shows4={{{shows4|}}}|width={{{width|}}}|groupBy={{{groupBy|}}}|where={{{where|}}}|limit={{{limit|500}}}|offset={{{offset|0}}} }}<!--

--></includeonly><includeonly>[[Category:Queries card data]]</includeonly><noinclude>{{Card query|collectible=1|cost=6|format=Standard|limit=100}}
[[Category:Query templates]]</noinclude>