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 = 622 GROUP BY p.plyrcard_cid ORDER BY s.set_name ASC, c.card_name ASC

Matches in akkrann's Collection

(1 results found, 1 total cards)

Num	Name	Type	Set	Cost	P/T	Rarity	Color
1	Island	Basic Land - Is...	Unglued			Common	nocolor