Query Syntax Help

Note: All queries are case-insensitive. Field names, values, and text searches all ignore case. e:fire, E:FIRE, and element:FiRe all work identically.

Name search - search card names (default search when no field specified)

Syntax

Just type the name (no field prefix)

Wildcards

  • * - Match any characters (zero or more)
  • ? - Match exactly one character
  • fire* - Names starting with "fire"
  • *spirit - Names ending with "spirit"

Without wildcards, searches match anywhere in the name (contains search).


Element search - filter cards by element

Syntax

element:value or e:value

Element Shortcuts

Basic Elements:

  • Norm: norm, n, grey, gray, y
  • Fire: fire, f, red, r
  • Water: water, w, blue, u
  • Wind: wind, i, green, g

Advanced Elements:

  • Crux: crux, spirit
  • Luxem: luxem, light
  • Tera: tera, earth
  • Arcane: arcane, lightning
  • Umbra: umbra, shadow
  • Astra: astra, stars
  • Neos: neos, creation
  • Exia: exia, rage
  • Exalted: exalted, ex

Categories:

  • basic or b - Any of Fire, Water, Wind
  • advanced, adv, or a - Any of the 9 advanced elements

Text search - search in effect text, flavor text, or illustrator name

Syntax

Effect text:

  • effect:value, fx:value, or o:value

Flavor text:

  • flavor:value or ft:value

Illustrator:

  • illustrator:value, artist:value, a:value, or i:value

Empty Values

Use an empty value to find cards without text in that field:

  • fx: - Vanilla cards (no effect text)
  • ft: - Cards with no flavor text
  • i: - Cards with no illustrator

Quoted Strings

Use double quotes to search for multi-word phrases. Without quotes, spaces separate

different search terms.

  • fx:"floating memory" searches for the phrase "floating memory"
  • fx:floating memory searches for "floating" in effect AND "memory" in name

Cost search - filter cards by memory cost, reserve cost, or either

Syntax

Memory cost:

  • memory:value, mem:value, or mc:value

Reserve cost:

  • reserve:value, res:value, or rc:value

Either cost (checks both memory and reserve):

  • cost:value or c:value

Supports comparison operators: :, =, >, >=, <, <=

Valid Values

Non-negative integers (0, 1, 2, 3, ...) or X


Numeric search - filter by numeric stats (power, life, durability, level)

Syntax

Power:

  • power:value or pow:value

Life:

  • life:value

Durability:

  • durability:value or dur:value

Level:

  • level:value or lv:value

Supports comparison operators: :, =, >, >=, <, <=


Collector number search - filter by collector number

Syntax

collector:value or cn:value

Supports comparison operators: :, =, >, >=, <, <=


Typeline search - search the full card typeline

The typeline on a card is formatted as: "Supertype(s) Type — Class Subtypes"

For example: "Champion — Warrior Human" or "Unique Regalia — Weapon Sword"

Syntax

Search the full typeline (types, classes, and subtypes):

  • t:value, type:value, typeline:value, or tl:value

Search only supertypes:

  • super:value or supertype:value

Search only card types:

  • ct:value or cardtype:value

Search only subtypes:

  • sub:value or subtype:value

Common Card Types

Action, Attack, Regalia, Ally, Item, Champion, Aura, Domain, Spirit

Classes (also searchable via t:)

Warrior, Mage, Ranger, Tamer, Assassin, Guardian, Cleric, Spirit, Anomaly


Class search - filter cards by character class

Syntax

class:value or cl:value

Valid Classes

Anomaly, Assassin, Cleric, Guardian, Mage, Ranger, Spirit, Tamer, Warrior


Rarity search - filter cards by rarity level

Syntax

rarity:value or r:value

Supports comparison operators: :, =, >, >=, <, <=

Rarity Codes

  • Common: c or 1
  • Uncommon: u or 2
  • Rare: r or 3
  • Super Rare: sr or 4
  • Ultra Rare: ur or 5
  • Promotional: pr or 6
  • Cold Stamped Rare: csr or 7
  • Cold Stamped Ultra Rare: cur or 8
  • Cold Stamped Promotional: cpr or 9

Speed search - filter by card speed (fast/slow actions and attacks)


Set search - filter cards by set code or full set name

Syntax

set:value or s:value

Wildcards

Supports * (any characters) and ? (single character):

  • s:ALC* - All Alchemical Revolution sets (ALCSD, ALC 1st, ALC Alter)
  • s:*SD - All starter deck sets
  • s:*Alter* - Sets with "Alter" in the name

Common Set Codes

DEMO23, ALCSD, DTRSD, AMBSD, etc.


Edition search - control which printings of a card appear in results

Syntax

edition:value

Special Values

  • all - Show all printings instead of grouping by card name

Deck type search - filter by main deck, material deck, or cards not in any deck

Syntax

deck:value

Valid Values

  • main - Cards with reserve costs (go in main deck)
  • material, mat, or side - Champions and regalia (go in material deck)
  • none - Tokens and masteries (not in any deck)

Flip card search - find cards with two faces (dual-sided cards)

Syntax

is:flip, is:flippable, is:reversable, or is:dfc

Negation

Use not: prefix as synonym for !is::

  • not:flip - Exclude flip cards (same as !is:flip)
  • not:dfc - Same as not:flip

Price search - filter cards by offer price

Syntax

Generic price (any currency):

  • price<50 - Cards under $50 (in any currency)

Currency-specific:

  • nzd<50 - Cards under $50 NZD (NZ stores only)
  • aud<50 - Cards under $50 AUD (AU stores only)

Supports comparison operators: :, =, >, >=, <, <=

Currency-Specific Behavior

Currency filters (nzd, aud) only match stores using that currency.

For example, nzd>4 in-stock:heretics-haven returns no results because

Heretic's Haven uses AUD, not NZD.

Notes

When combined with other offer conditions like in-stock:, all conditions

must match the same offer.


In-stock search - filter cards by store availability

Syntax

in-stock:store-slug or in-stock:"Store Name" or in-stock:any

Boolean Form

Use is:in-stock as a shorthand for in-stock:any:

  • is:in-stock - Has any in-stock offers

Negation

Use not: prefix as synonym for !is::

  • not:in-stock - Exclude cards with in-stock offers (same as !is:in-stock)

Combined Queries

When combined with price searches, conditions match the same offer:

  • price<50 in-stock:cm-nelson - Under $50 at Card Merchant Nelson
  • price<20 (in-stock:cm-nelson OR in-stock:fetch) - Under $20 at either store

Foil search - filter cards with foil finish offers

Syntax

is:foil

Negation

Use not: prefix as synonym for !is::

  • not:foil - Exclude foil offers (same as !is:foil)

Notes

This searches for offers with foil finish. When combined with other offer

conditions, all conditions must match the same offer.


Rulings search - find cards that have official rulings/errata

Syntax

has:rulings or has:ruling

Notes

Rulings are official clarifications or errata issued for a card.

Use this to find cards that have received official rule clarifications.


Legality search - filter cards by format legality status

Syntax

legal:format, banned:format, restricted:format

Valid Formats

  • standard - Standard constructed format
  • limited - Limited/draft format

References search - filter cards by what they reference or are referenced by

Syntax

ref:name, refby:name

Reference Types

Cards can reference others through:

  • Summon - Token creation (e.g., Tristan summons Ominous Shadow)
  • Generate - Card generation (e.g., Polaris generates Cosmic Bolt)
  • Mastery - Mastery card references
  • Brew - Brewing references
  • Reference - Generic card references

Competitive stats search - filter cards by tournament performance data

Syntax

Appearances (all-time):

  • app:value, apps:value, appearances:value

Appearances (60 days):

  • app60:value, apps60:value, appearances60:value

Win Rate (all-time, as percentage):

  • wr:value, winrate:value

Win Rate (60 days, as percentage):

  • wr60:value, winrate60:value

Supports comparison operators: :, =, >, >=, <, <=

Notes

Win rates are entered as percentages (0-100). A query like wr60>54

finds cards with a 60-day win rate above 54%.

Cards without competitive data (never appeared in tournaments) won't

match any competitive stat queries.


Language search - filter cards by language code

Syntax

lang:value or language:value

Valid Values

Two-letter language codes (case-insensitive): EN, CN, JP, KR, etc.


Release date search - filter cards by release date

Syntax

date:value, release:value, or released:value

Supports comparison operators: :, =, >, >=, <, <=

Date Formats

  • Year only: 2024
  • Year-Month: 2024-01
  • Full date: 2024-01-15

Comparison Logic

Partial dates are expanded to ranges for comparisons:

  • date:2024 matches any date in 2024 (LIKE '2024%')
  • date>2024 matches dates after all of 2024 (> '2024-12-31')
  • date>=2024 matches dates from start of 2024 (>= '2024-01-01')
  • date<2024 matches dates before 2024 (< '2024-01-01')
  • date<=2024 matches dates through end of 2024 (<= '2024-12-31')

Query Syntax Overview

Boolean Logic

Combine multiple search criteria with boolean operators:

AND Operator

Use AND (or &&) to find cards matching all criteria:

  • silvie AND warrior - Cards with "silvie" in name AND warrior class
  • fx:draw AND c<=2 - Cards with "draw" in effect text AND cost 2 or less
  • fire AND action - Fire element cards that are actions

OR Operator

Use OR (or ||) to find cards matching any criteria:

  • silvie OR lorraine - Cards with either name
  • e:fire OR e:water - Fire or Water element cards
  • r:sr OR r:ur - Super Rare or Ultra Rare cards

NOT Operator

Use NOT (or !) to exclude cards matching a criterion:

  • warrior NOT silvie - Warrior class cards except Silvie
  • e:fire NOT t:regalia - Fire cards that aren't regalia
  • action NOT c:0 - Actions that don't cost 0

Parentheses

Use parentheses to control evaluation order:

  • (silvie OR lorraine) AND warrior - Either Silvie or Lorraine, both warriors
  • e:fire AND (t:action OR t:attack) - Fire actions or attacks
  • NOT (r:c OR r:u) - Exclude commons and uncommons

Note: AND has higher precedence than OR. a OR b AND c means a OR (b AND c).

Quoted Strings

Use double quotes to search for multi-word phrases or values with special characters:

  • "spirit of fire" - Search for the exact phrase
  • fx:"draw a card" - Effect text with "draw a card"
  • "Spellshield: Astra" - Card names containing colons need quotes

Without quotes, spaces separate different search terms:

  • spirit fire means name contains "spirit" AND name contains "fire"
  • fx:floating memory means effect contains "floating" AND name contains "memory"

Comparison Operators

Numeric and ordinal fields support comparison operators:

  • : or = - Equal to
  • > - Greater than
  • >= - Greater than or equal to
  • < - Less than
  • <= - Less than or equal to

Examples:

  • c:3 or c=3 - Cost exactly 3
  • r>c - Rarity higher than Common
  • power>=5 - Power 5 or greater
  • cn<=100 - Collector number 100 or less

Example Queries

Here are some complex examples combining multiple features:

  • e:fire AND cl:warrior AND power>=5 - Find powerful fire warriors
  • fx:"draw" AND (e:water OR e:crux) - Search for card draw effects
  • t:action AND sp:fast AND c<=2 - Find cheap fast actions
  • e:wind AND NOT (t:champion OR t:regalia) - Exclude specific card types
  • (s:alcsd OR s:demo23) AND r>=sr - Search across multiple sets

Known Limitations

Card names with colons: Because the colon (:) is used for field searches, card names containing colons (like "Spellshield: Astra") must be quoted to search correctly: "Spellshield: Astra". Without quotes, the parser will try to interpret the part before the colon as a field name. This is a known limitation that may be improved in future versions.

← Back to Home