Magic the Gathering Advanced Card Search

Card Name:
Card Type:
Card Text:
Card Flavor:
Artist:
Set:	All Alara Reborn Alliances Antiquities Apocalypse Arabian Nights Archenemy Battle Royale Box Set Beatdown Box Set Betrayers of Kamigawa Champions of Kamigawa Chronicles Classic Sixth Edition Coldsnap Commander Conflux Darksteel Dissension Duel Decks: Divine vs. Demonic Duel Decks: Elspeth vs. Tezzeret Duel Decks: Elves vs. Goblins Duel Decks: Garruk vs. Liliana Duel Decks: Jace vs. Chandra Duel Decks: Knights vs Dragons Duel Decks: Phyrexia vs The Coalition Eighth Edition Eventide Exodus Fallen Empires Fifth Dawn Fifth Edition Fourth Edition From the Vault: Dragons From the Vault: Exiled Future Sight Guildpact Homelands Ice Age Invasion Judgment Legends Legions Limited Edition Alpha Limited Edition Beta Lorwyn Magic 2010 Magic 2011 Magic 2012 Mercadian Masques Mirage Mirrodin Mirrodin Besieged Morningtide Nemesis New Phyrexia Ninth Edition Odyssey Onslaught Planar Chaos Planechase Planeshift Portal Portal Second Age Portal Three Kingdoms Premium Deck Series: Fire and Lightning Premium Deck Series: Slivers Prophecy Ravnica: City of Guilds Revised Edition Rise of the Eldrazi Saviors of Kamigawa Scars of Mirrodin Scourge Seventh Edition Shadowmoor Shards of Alara Starter 1999 Starter 2000 Stronghold Tempest Tenth Edition The Dark Time Spiral Time Spiral - Timeshifted Torment Unglued Unhinged Unlimited Edition Urza's Destiny Urza's Legacy Urza's Saga Visions Weatherlight Worldwake Zendikar
Rarity:	All Common Land Mythic Rare Rare Special Uncommon
Cost Colors:	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 = 27 GROUP BY p.plyrcard_cid ORDER BY s.set_name ASC, c.card_name ASC

Matches in Bubblehead's Collection

(38 results found, 165 total cards)

Num	Name	Type	Set	Cost	P/T	Rarity	Color
1	Snow-Covered Is...	Basic Snow Land...	Coldsnap			Common	nocolor
6	Island	Basic Land - Is...	Duel Decks: Jac...			Land	nocolor
6	Island	Basic Land - Is...	Duel Decks: Jac...			Land	nocolor
6	Island	Basic Land - Is...	Duel Decks: Jac...			Land	nocolor
5	Island	Basic Land - Is...	Duel Decks: Jac...			Land	nocolor
1	Island	Basic Land - Is...	Eighth Edition			Land	nocolor
6	Island	Basic Land - Is...	Magic 2010			Land	nocolor
5	Island	Basic Land - Is...	Magic 2010			Land	nocolor
7	Island	Basic Land - Is...	Magic 2010			Land	nocolor
5	Island	Basic Land - Is...	Magic 2010			Land	nocolor
1	Island	Basic Land - Is...	Mirage			Land	nocolor
1	Island	Basic Land - Is...	Mirage			Land	nocolor
1	Island	Basic Land - Is...	Mirage			Land	nocolor
1	Island	Basic Land - Is...	Mirage			Land	nocolor
5	Island	Basic Land - Is...	Ravnica: City o...			Land	nocolor
3	Island	Basic Land - Is...	Ravnica: City o...			Land	nocolor
2	Island	Basic Land - Is...	Ravnica: City o...			Land	nocolor
2	Island	Basic Land - Is...	Ravnica: City o...			Land	nocolor
1	Moonring Island	Land - Island	Shadowmoor			Uncommon	nocolor
16	Island	Basic Land - Is...	Shards of Alara			Land	nocolor
13	Island	Basic Land - Is...	Shards of Alara			Land	nocolor
14	Island	Basic Land - Is...	Shards of Alara			Land	nocolor
16	Island	Basic Land - Is...	Shards of Alara			Land	nocolor
1	Island	Basic Land - Is...	Tempest			Land	nocolor
1	Island	Basic Land - Is...	Tempest			Land	nocolor
1	Island	Basic Land - Is...	Tempest			Land	nocolor
1	Island	Basic Land - Is...	Tempest			Land	nocolor
4	Island	Basic Land - Is...	Time Spiral			Land	nocolor
4	Island	Basic Land - Is...	Time Spiral			Land	nocolor
1	Island	Basic Land - Is...	Time Spiral			Land	nocolor
3	Island	Basic Land - Is...	Time Spiral			Land	nocolor
2	Island	Basic Land - Is...	Unglued			Common	nocolor
1	Island	Basic Land - Is...	Urza's Saga			Land	nocolor
1	Island	Basic Land - Is...	Urza's Saga			Land	nocolor
1	Island	Basic Land - Is...	Urza's Saga			Land	nocolor
1	Island	Basic Land - Is...	Urza's Saga			Land	nocolor
1	Island	Basic Land - Is...	Zendikar			Land	nocolor
18	Island	Basic Land - Is...	Zendikar		--	Land	nocolor