Template: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

The following documentation is transcluded from Template:Card query/doc (edit):

Parameters used in Card query. When using multiple values, pageName, name, dbfId, dbfIdNot, id, and text are split by &&, others are split by a comma (,).

Template parameters

This template prefers inline formatting of parameters.

Parameter		Description	Type	Status
layout	layout	Choose one of these layouts: table, image, or count. Default is table.	String	optional
footer	footer	Footer to be displayed under the card image.	String	optional
where	where	Where clauses, pretty much like SQL functions.	String	optional
format	format	Formats from DerivedCard table (Standard, Wild, Twist, Duels, Arena, Classic, Boss)	String	optional
formatNot	formatNot	Exclude formats	String	optional
collectible	collectible	1 for collectible, 0 for no, leave blank for both	Boolean	optional
name	name	Name of the card	String	optional
dbfId	dbfId	dbfId of the card	Number	optional
dbfIdNot	dbfIdNot	Exclude dbfIds	Number	optional
id	id	id of the card	String	optional
text	text	Text on the card's textbox (if any apply)	String	optional
textAdvanced	textAdvanced	Text on the card's textbox (if ALL apply)	String	optional
cost	cost	no description	Unknown	optional
costNot	costNot	no description	Unknown	optional
costMore	costMore	no description	Unknown	optional
costLess	costLess	no description	Unknown	optional
costOdd	costOdd	no description	Unknown	optional
costEven	costEven	no description	Unknown	optional
attack	attack	no description	Unknown	optional
attackNot	attackNot	no description	Unknown	optional
attackMore	attackMore	no description	Unknown	optional
attackLess	attackLess	no description	Unknown	optional
health	health	no description	Unknown	optional
healthNot	healthNot	no description	Unknown	optional
healthMore	healthMore	no description	Unknown	optional
healthLess	healthLess	no description	Unknown	optional
dura	dura	no description	Unknown	optional
duraNot	duraNot	no description	Unknown	optional
duraMore	duraMore	no description	Unknown	optional
duraLess	duraLess	no description	Unknown	optional
armor	armor	no description	Unknown	optional
armorNot	armorNot	no description	Unknown	optional
armorMore	armorMore	no description	Unknown	optional
armorLess	armorLess	no description	Unknown	optional
costVSattack	costVSattack	no description	Unknown	optional
costVShealth	costVShealth	no description	Unknown	optional
costVSdura	costVSdura	no description	Unknown	optional
attackVShealth	attackVShealth	no description	Unknown	optional
attackVSdura	attackVSdura	no description	Unknown	optional
sets	sets	no description	Unknown	optional
setsNot	setsNot	no description	Unknown	optional
core	core	no description	Unknown	optional
classes	classes	no description	Unknown	optional
classesAll	classesAll	no description	Unknown	optional
classesNot	classesNot	no description	Unknown	optional
multiClassGroups	multiClassGroups	no description	Unknown	optional
multiClassGroupsNot	multiClassGroupsNot	no description	Unknown	optional
types	types	no description	Unknown	optional
typesNot	typesNot	no description	Unknown	optional
races	races	no description	Unknown	optional
racesNot	racesNot	no description	Unknown	optional
spellSchools	spellSchools	no description	Unknown	optional
spellSchoolsNot	spellSchoolsNot	no description	Unknown	optional
rarities	rarities	no description	Unknown	optional
raritiesNot	raritiesNot	no description	Unknown	optional
artists	artists	no description	Unknown	optional
artistsNot	artistsNot	no description	Unknown	optional
signatureArtists	signatureArtists	no description	Unknown	optional
signatureArtistsNot	signatureArtistsNot	no description	Unknown	optional
vfxArtists	vfxArtists	no description	Unknown	optional
vfxArtistsNot	vfxArtistsNot	no description	Unknown	optional
voiceActors	voiceActors	no description	Unknown	optional
voiceActorsNot	voiceActorsNot	no description	Unknown	optional
keywordTags	keywordTags	no description	Unknown	optional
keywordTagsAll	keywordTagsAll	no description	Unknown	optional
keywordTagsNot	keywordTagsNot	no description	Unknown	optional
referencedTags	referencedTags	no description	Unknown	optional
referencedTagsAll	referencedTagsAll	no description	Unknown	optional
referencedTagsNot	referencedTagsNot	no description	Unknown	optional
stringTags	stringTags	no description	Unknown	optional
stringTagsAll	stringTagsAll	no description	Unknown	optional
stringTagsNot	stringTagsNot	no description	Unknown	optional
customTags	customTags	no description	Unknown	optional
customTagsAll	customTagsAll	no description	Unknown	optional
customTagsNot	customTagsNot	no description	Unknown	optional
customReferencedTags	customReferencedTags	no description	Unknown	optional
customReferencedTagsAll	customReferencedTagsAll	no description	Unknown	optional
customReferencedTagsNot	customReferencedTagsNot	no description	Unknown	optional
customHiddenTags	customHiddenTags	no description	Unknown	optional
customHiddenTagsAll	customHiddenTagsAll	no description	Unknown	optional
customHiddenTagsNot	customHiddenTagsNot	no description	Unknown	optional
customCycles	customCycles	no description	Unknown	optional
customCyclesAll	customCyclesAll	no description	Unknown	optional
customCyclesNot	customCyclesNot	no description	Unknown	optional
customExclusions	customExclusions	no description	Unknown	optional
customExclusionsAll	customExclusionsAll	no description	Unknown	optional
customExclusionsNot	customExclusionsNot	no description	Unknown	optional
custom_races	custom_races	no description	Unknown	optional
custom_racesAll	custom_racesAll	no description	Unknown	optional
custom_racesNot	custom_racesNot	no description	Unknown	optional
custom_racesInArt	custom_racesInArt	no description	Unknown	optional
custom_racesInArtNot	custom_racesInArtNot	no description	Unknown	optional
runeBlood	runeBlood	no description	Unknown	optional
runeFrost	runeFrost	no description	Unknown	optional
runeUnholy	runeUnholy	no description	Unknown	optional
orderBy	orderBy	Order to sort the results. Default is CardTag.cost ASC, Card.name ASC	String	optional
limit	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	Number	optional
offset	offset	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.	Number	optional
intro	intro	Data to be presented before the query	Content	optional
collapsed	collapsed	If true (default), the table/card image list will be collapsed after the page is reloaded, and vice versa if false.	Boolean	optional
title	title	Title to be presented at the top of the query	String	optional
outro	outro	Data to be presented after the query	Content	optional
default	default	Content to be presented if no cards are found	Content	optional

---

Examples

Name	Class	Type	Rarity	Cost	Atk	HP/Dur.	Armor	Description
Aggramar, the Avenger		Minion		6	3	7		Titan Battlecry: Equip a 3/3 Taeshalach.
Blast Tortoise		Minion - Beast		6	2	7		Taunt Battlecry: Deal damage to all enemy minions equal to this minion's Attack.
Blastmage Miner		Minion		6	4	4		Battlecry: Excavate a treasure. For each card in your hand, deal 1 damage to a random enemy.
Blizzard		Spell - Frost		6				Deal 2 damage to all enemy minions and Freeze them.
Boulderfist Ogre		Minion		6	6	7
Chaos Creation		Spell - Fel		6				Deal 6 damage. Summon a random 6-Cost minion. Destroy the bottom 6 cards of your deck.
Cho'gall, Twilight Chieftain		Minion		6	6	7		Taunt, Lifesteal Start of Game: 50% chance to corrupt the game with a random anomaly.
Clay Matriarch		Minion - Dragon		6	3	7		Miniaturize Taunt. Deathrattle: Summon a 4/4 Whelp with Elusive.
Crystal Cluster		Spell		6				Gain three empty Mana Crystals. Any that can't fit summon a 3/7 Elemental with Taunt.
Deepminer Brann		Minion		6	2	4		Battlecry: If your deck has no duplicates, your Battlecries trigger twice for the rest of the game.
Dirge of Despair		Spell - Shadow		6				Deal 3 damage to a character. If that kills it, summon a Demon from your deck.
Doomkin		Minion		6	3	4		Battlecry: Take one of your opponent's empty Mana Crystals.
Dr. Stitchensew		Minion - Undead		6	6	4		Battlecry: Discover a 5, 3, and 1-Cost minion to stitch to this. Deathrattle: Summon the 5-Cost minion.
Druid of the Claw		Minion		6	4	6		Choose One - Transform into a 7/6 with Rush; or a 4/9 with Taunt.
Evasive Wyrm		Minion - Dragon		6	5	3		Rush Divine Shield Elusive
Fire Elemental		Minion - Elemental		6	6	5		Battlecry: Deal 4 damage.
Flame Behemoth		Minion - Mech		6	4	5		Battlecry: Get two random Magnetic Mechs. They cost (2) less.
Flik Skyshiv		Minion		6	4	4		Battlecry: Destroy a minion and all copies of it (wherever they are).
Frostmourne		Weapon		6	4	3		Deathrattle: Summon every minion killed by this weapon.
Gnome Muncher		Minion - Undead		6	5	6		Taunt, Lifesteal At the end of your turn, attack the lowest Health enemy.
Gnomelia, S.A.F.E. Pilot		Minion		6	4	2		Rush. Also damages minions next to whomever this attacks. Deathrattle: Deal 2 damage to all enemies.
Golganneth, the Thunderer		Minion		6	5	7		Titan Your first spell each turn costs (3) less.
Hammer of the Naaru		Weapon		6	3	3		Battlecry: Summon a 6/6 Holy Elemental with Taunt.
Harmonic Pop		Spell - Holy		6				Deal 3 damage to all minions. Summon a 6/6 Popstar. (Swaps each turn.)
Harth Stonebrew		Minion		6	5	5		Battlecry: Replace your hand with an iconic one from Hearthstone's past. (Once per game)
Hollow Hound		Minion - Undead/Beast		6	3	4		Lifesteal, Rush Also damages minions next to whomever this attacks.
Horn of the Windlord		Weapon		6	3	4		Windfury Whenever your hero attacks a minion, set its stats to 3/3.
Khaz'goroth		Minion		6	4	5		Titan After this uses an ability, gain Immune this turn and attack a random enemy minion.
Kingpin Pud		Minion		6	6	7		Battlecry: Resurrect your Ogre-Gang. Give them Windfury.
Lead Dancer		Minion		6	4	2		Deathrattle: Summon a minion from your deck with less Attack than this minion.
Li'Na, Shop Manager		Minion		6	3	3		Whenever you cast a spell, fill your board with random minions of that Cost.
Lightbomb		Spell - Holy		6				Deal damage to each minion equal to its Attack.
Loken, Jailer of Yogg-Saron		Minion		6	3	3		Battlecry: Discover a minion from your deck. Summon a Tentacle with its stats and Taunt.
Manufacturing Error		Spell		6				Draw 3 cards. If your deck has no minions, they cost (3) less.
Marrow Manipulator		Minion - Undead		6	5	5		Battlecry: Spend up to 5 Corpses. Deal 2 damage to a random enemy for each.
Mes'Adune the Fractured		Minion - Elemental		6	6	5		Battlecry: Draw an Elemental. Split it into two halves.
Midnight Wolf		Minion - Beast		6	6	6		Rush Outcast: Summon a copy of this.
Minotauren		Minion		6	5	5		Rush Whenever this minion deals damage, gain that much Armor.
Mister Mukla		Minion - Beast		6	10	10		Rush. Battlecry: Fill your opponent's hand with Bananas.
Norgannon		Minion		6	3	8		Titan After this uses an ability, double the power of the other abilities.
Obsidian Revenant		Minion - Elemental		6	4	6		Taunt Deathrattle: Summon two random Deathrattle minions that cost (3) or less.
Once Upon a Time...		Spell - Nature		6				Summon a random 3-Cost Beast, Dragon, Elemental, and Murloc.
Origami Dragon		Minion - Dragon		6	1	1		Divine Shield, Lifesteal Battlecry: Swap stats with another minion.
Puzzlemaster Khadgar		Minion		6	5	5		Battlecry: Equip a 0/6 Wisdomball that casts helpful Mage spells!
Ra-den		Minion		6	5	5		Taunt. Deathrattle: Summon each other minion you've played this game that didn't start in your deck.
Savannah Highmane		Minion - Beast		6	7	5		Deathrattle: Summon two 2/2 Hyenas.
Shoplifter Goldbeard		Minion - Pirate		6	5	5		After you summon a Pirate, summon a copy of it that attacks a random enemy, then dies.
Shudderblock		Minion		6	5	5		Miniaturize Battlecry: Your next Battlecry triggers 3 times, but can't damage the enemy hero.
Sif		Minion		6	4	6		Spell Damage +1 (Improved by each spell school you've cast this game!)
Spikeridged Steed		Spell		6				Give a minion +2/+6 and Taunt. When it dies, summon a Stegodon.
Starstrung Bow		Weapon		6	5	2		Costs (1) less for each friendly Secret that has triggered this game.
Stone Drake		Minion - Dragon/Elemental		6	2	8		Divine Shield, Taunt, Lifesteal Can't be targeted by spells or Hero Powers.
Sunspot Dragon		Minion - Dragon		6	6	6		Tradeable, Lifesteal Quickdraw: Deal 6 damage.
Sylvanas Windrunner		Minion - Undead		6	5	5		Deathrattle: Take control of a random enemy minion.
Testing Dummy		Minion - Mech		6	4	8		Taunt Deathrattle: Deal 8 damage randomly split among all enemies.
The Badlands Bandits		Spell		6				Get eight 3/2 Bandits with bonus effects. Any that can't fit in your hand are summoned instead.
The Headless Horseman		Hero		6		30	5	Battlecry: Destroy the enemy minion with the most Attack! Shuffle my Head into your deck, you must get it back!
Thing from Below		Minion		6	5	5		Taunt Costs (1) less for each Totem you've summoned this game.
Thirsty Drifter		Minion		6	4	6		Taunt Costs (1) less for each 1-Cost card you've played this game.
Trial by Fire		Spell - Fire		6				Summon five 1/1 Val'kyr with Rush. When one dies, give the others +1/+1.
Tyr		Minion		6	4	5		Battlecry: Resurrect a 2, 3, and 4-Attack Paladin minion.
Unpopular Has-Been		Minion - Undead		6	5	5		Deathrattle: Summon a random 5-Cost minion from the past.
V-07-TR-0N Prime		Minion - Mech		6	3	5		T1T4N This minion's abilities repeat on another random friendly minion.
Wind-Up Enforcer		Minion		6	3	5		Tradeable Battlecry: Summon 1 copy of this minion. (Trade to upgrade!)
Wind-Up Musician		Minion		6	5	5		Tradeable Battlecry: Deal 1 damage to all enemy minions. (Trade to upgrade!)