Magic the Gathering Advanced Card Search

Card Name:
Card Type:
Card Text:
Card Flavor:
Artist:
Set:
Rarity:
Cost Colors: Blue mana symbol Red mana symbol White mana symbol Black mana symbol Green mana symbol
strict color search (narrower results)
SELECT c.*, s.set_name, s.set_id, COUNT(p.plyrcard_cid) as card_quant FROM cards c LEFT JOIN sets s ON c.card_setid = s.set_id INNER JOIN player_cards p ON p.plyrcard_cid = c.card_id WHERE c.card_name LIKE '%Island%' AND p.plyrcard_pid = 805 GROUP BY p.plyrcard_cid ORDER BY s.set_name ASC, c.card_name ASC

Matches in kermione's Collection

(40 results found, 180 total cards)

Sort Order:
Num
sort arrow sort arrow sort arrow sort arrow
Name
sort arrow sort arrow sort arrow sort arrow
Type
sort arrow sort arrow sort arrow sort arrow
Set
sort arrow sort arrow sort arrow sort arrow
Cost
sort arrow sort arrow sort arrow sort arrow
P/T
sort arrow sort arrow sort arrow sort arrow
Rarity
sort arrow sort arrow sort arrow sort arrow
Color
sort arrow sort arrow sort arrow sort arrow
9   Island Basic Land - Is...Classic Sixth E...Landnocolor
11   Island Basic Land - Is...Classic Sixth E...Landnocolor
4   Island Basic Land - Is...Fifth EditionLandnocolor
5   Island Basic Land - Is...Fifth EditionLandnocolor
3   Island Basic Land - Is...Fifth EditionLandnocolor
5   Island Basic Land - Is...Fifth EditionLandnocolor
1   Island Basic Land - Is...Ice AgeLandnocolor
1   Island Basic Land - Is...Ice AgeLandnocolor
5   Island Basic Land - Is...InvasionLandnocolor
5   Island Basic Land - Is...InvasionLandnocolor
4   Island Basic Land - Is...InvasionLandnocolor
4   Island Basic Land - Is...InvasionLandnocolor
1   Island Basic Land - Is...Magic 2012Landnocolor
4   Island Basic Land - Is...Mercadian MasquesLandnocolor
4   Island Basic Land - Is...Mercadian MasquesLandnocolor
4   Island Basic Land - Is...Mercadian MasquesLandnocolor
3   Island Basic Land - Is...Mercadian MasquesLandnocolor
4   Island Basic Land - Is...MirageLandnocolor
2   Island Basic Land - Is...MirageLandnocolor
2   Island Basic Land - Is...MirageLandnocolor
6   Island Basic Land - Is...MirageLandnocolor
2   Island Basic Land - Is...OdysseyLandnocolor
2   Island Basic Land - Is...OdysseyLandnocolor
2   Island Basic Land - Is...OdysseyLandnocolor
2   Island Basic Land - Is...PortalLandnocolor
1   Island Basic Land - Is...PortalLandnocolor
6   Island Basic Land - Is...Portal Second AgeLandnocolor
6   Island Basic Land - Is...Portal Second AgeLandnocolor
6   Island Basic Land - Is...Portal Second AgeLandnocolor
5   Island Basic Land - Is...Revised EditionLandnocolor
2   Island Basic Land - Is...Starter 1999Landnocolor
2   Island Basic Land - Is...Starter 1999Landnocolor
2   Island Basic Land - Is...Starter 1999Landnocolor
2   Island Basic Land - Is...Starter 1999Landnocolor
10   Island Basic Land - Is...TempestLandnocolor
23   Island Basic Land - Is...TempestLandnocolor
4   Island Basic Land - Is...Urza's SagaLandnocolor
5   Island Basic Land - Is...Urza's SagaLandnocolor
6   Island Basic Land - Is...Urza's SagaLandnocolor
5   Island Basic Land - Is...Urza's SagaLandnocolor