Card query

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

Usage

{{Card query
 |layout=
 |where=
 |orderBy=
 |collapsed=
 |limit=
 |offset=
}}

Parameters

• layout: Choose one of these layouts: table, image, or count. Default is table.
• where: Where clauses, pretty much like SQL functions.
• orderBy: Order to sort the results. Default is Cards.cost ASC, Cards.name ASC.
• collapsed: If true (default), the table/card image list will be collapsed after the page is reloaded, and vice versa if false.
• limit: 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
• offset: the number of initial cards to skip. This combines with limit for separating lists whose the number of results are very high into individual pages/articles.

Examples

Name	Class	Type	Rarity	Cost	Atk	HP/Dur.	Armor	Description
Abyssal Wave		Spell	Epic	6				Deal 4 damage to all minions. Give your opponent an Abyssal Curse.
Anetheron		Minion	Legendary	6	8	6		Costs (1) if your hand is full.
Balinda Stonehearth		Minion	Legendary	6	5	5		Battlecry: Draw 2 spells. Swap their Costs with this minion's stats.
Barbaric Sorceress		Minion	Common	6	3	7		Taunt. Battlecry: Swap the Cost of a random spell in each player's hand.
Barrens Scavenger		Minion	Epic	6	6	6		Taunt Costs (1) while your deck has 10 or fewer cards.
Battleground Battlemaster		Minion	Common	6	5	5		Adjacent minions have Windfury.
Beaststalker Tavish		Hero	Legendary	6		30	5	Battlecry: Discover and cast 2 Improved Secrets.
Best in Shell		Spell	Common	6				Tradeable Summon two 2/7  Turtles with Taunt.
Blizzard		Spell	Rare	6				Deal 2 damage to all enemy minions and Freeze them.
Blood in the Water		Spell	Common	6				Deal 3 damage to an enemy. Summon a 5/5 Shark with Rush.
Cairne Bloodhoof		Minion	Legendary	6	5	5		Deathrattle: Summon a 5/5 Baine Bloodhoof.
Captain Galvangar		Minion	Legendary	6	6	6		Battlecry: If you have gained 15 or more Armor this game, gain +3/+3 and Charge.@ ({0} left!)@ (Ready!)
City Architect		Minion	Common	6	4	4		Battlecry: Summon two 0/5 Castle Walls with Taunt.
Coilskar Commander		Minion	Epic	6	2	6		Taunt. Battlecry: If you've cast three spells while holding this, summon two   copies of this.@ ({0} left!)@ (Ready!)
Cornelius Roame		Minion	Legendary	6	4	5		At the start and end  of each player's turn, draw a card.
Cowardly Grunt		Minion	Rare	6	6	2		Deathrattle: Summon a minion from your deck.
Crabatoa		Minion	Legendary	6	6	5		Colossal +2 Your Crabatoa Claws have +2 Attack.
Dreadlich Tamsin		Hero	Legendary	6		30	5	Battlecry: Deal 3 damage to all minions. Shuffle 3 Rifts into your deck. Draw 3 cards.
Entitled Customer		Minion	Epic	6	3	2		Battlecry: Deal damage equal to your hand size to all other minions.
Felwalker		Minion	Common	6	3	7		Taunt. Battlecry: Cast the highest Cost Fel spell from your hand.
Fire Elemental		Minion	Common	6	6	5		Battlecry: Deal 4 damage.
Floecaster		Minion	Common	6	5	5		Costs (2) less for each Frozen enemy.
Gadgetzan Auctioneer		Minion	Rare	6	4	4		Whenever you cast a spell, draw a card.
Glaciate		Spell	Rare	6				Discover an 8-Cost minion. Summon and Freeze it.
Green-Thumb Gardener		Minion	Rare	6	5	5		Battlecry: Refresh empty Mana Crystals equal to the Cost of the most expensive spell in your hand.
Grey Sage Parrot		Minion	Common	6	4	5		Battlecry: Repeat the last spell you've cast that costs (5) or more.
Highlord Fordragon		Minion	Legendary	6	5	5		Divine Shield After a friendly minion loses Divine Shield, give a minion   in your hand +5/+5.
Icehoof Protector		Minion	Common	6	2	10		Taunt Freeze any character damaged by this minion.
Impfestation		Spell	Rare	6				Summon a 3/3 Dread Imp to attack each enemy minion.
Krag'wa, the Frog		Minion	Legendary	6	4	6		Battlecry: Return all spells you played last turn to your hand.
Kresh, Lord of Turtling		Minion	Legendary	6	3	9		Frenzy: Gain 8 Armor. Deathrattle: Equip a 2/5 Turtle Spike.
Kurtrus, Demon-Render		Hero	Legendary	6		30	5	Battlecry: Summon two 1/4 Demons with Rush. (Improved by your hero attacks this game.)
Lady Anacondra		Minion	Legendary	6	3	7		Your Nature spells cost (2) less.
Lady Prestor		Minion	Legendary	6	6	7		Battlecry: Transform minions in your deck into random Dragons. (They keep their   original stats and Cost.)
Legionnaire		Minion	Common	6	9	3		Deathrattle: Give all minions in your hand +2/+2.
Lightbomb		Spell	Epic	6				Deal damage to each minion equal to its Attack.
Lightshower Elemental		Minion	Rare	6	6	6		Taunt Deathrattle: Restore 8 Health to all friendly characters.
Mi'da, Pure Light		Minion	Legendary	6	4	6		Divine Shield, Lifesteal Deathrattle: Shuffle a Fragment into your deck that resummons Mi'da when drawn.
Mossy Horror		Minion	Epic	6	2	7		Battlecry: Destroy all other minions with 2 or less Attack.
Mothership		Minion	Rare	6	5	4		Rush Deathrattle: Summon two random Mechs that cost (3) or less.
Proving Grounds		Spell	Rare	6				Summon two minions from your deck. They fight!
Rats of Extraordinary Size		Spell	Epic	6				Summon seven 1/1 Rats. Any that can't fit on the battlefield go to your hand with +4/+4.
Reno Jackson		Minion	Legendary	6	4	6		Battlecry: If your deck has no duplicates, fully heal your hero.
Savannah Highmane		Minion	Rare	6	6	5		Deathrattle: Summon two 2/2 Hyenas.
Snowfall Guardian		Minion	Common	6	3	3		Battlecry: Freeze all other minions. Gain +1/+1 for each Frozen minion.
Sprint		Spell	Rare	6				Draw 4 cards.
Stealer of Souls		Minion	Rare	6	4	6		After you draw a card, change its Cost to Health instead of Mana.
Taurajo Brave		Minion	Rare	6	4	8		Frenzy: Destroy a random enemy minion.
Tiny Toys		Spell	Epic	6				Summon four random 5-Cost minions. Make them 2/2.
Undying Disciple		Minion	Rare	6	3	7		Taunt Deathrattle: Deal damage equal to this minion's Attack to all enemy minions.