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 = 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)

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
1   Snow-Covered Is... Basic Snow Land...ColdsnapCommonnocolor
6   Island Basic Land - Is...Duel Decks: Jac...Landnocolor
6   Island Basic Land - Is...Duel Decks: Jac...Landnocolor
6   Island Basic Land - Is...Duel Decks: Jac...Landnocolor
5   Island Basic Land - Is...Duel Decks: Jac...Landnocolor
1   Island Basic Land - Is...Eighth EditionLandnocolor
6   Island Basic Land - Is...Magic 2010Landnocolor
5   Island Basic Land - Is...Magic 2010Landnocolor
7   Island Basic Land - Is...Magic 2010Landnocolor
5   Island Basic Land - Is...Magic 2010Landnocolor
1   Island Basic Land - Is...MirageLandnocolor
1   Island Basic Land - Is...MirageLandnocolor
1   Island Basic Land - Is...MirageLandnocolor
1   Island Basic Land - Is...MirageLandnocolor
5   Island Basic Land - Is...Ravnica: City o...Landnocolor
3   Island Basic Land - Is...Ravnica: City o...Landnocolor
2   Island Basic Land - Is...Ravnica: City o...Landnocolor
2   Island Basic Land - Is...Ravnica: City o...Landnocolor
1   Moonring Island Land - IslandShadowmoorUncommonnocolor
16   Island Basic Land - Is...Shards of AlaraLandnocolor
13   Island Basic Land - Is...Shards of AlaraLandnocolor
14   Island Basic Land - Is...Shards of AlaraLandnocolor
16   Island Basic Land - Is...Shards of AlaraLandnocolor
1   Island Basic Land - Is...TempestLandnocolor
1   Island Basic Land - Is...TempestLandnocolor
1   Island Basic Land - Is...TempestLandnocolor
1   Island Basic Land - Is...TempestLandnocolor
4   Island Basic Land - Is...Time SpiralLandnocolor
4   Island Basic Land - Is...Time SpiralLandnocolor
1   Island Basic Land - Is...Time SpiralLandnocolor
3   Island Basic Land - Is...Time SpiralLandnocolor
2   Island Basic Land - Is...UngluedCommonnocolor
1   Island Basic Land - Is...Urza's SagaLandnocolor
1   Island Basic Land - Is...Urza's SagaLandnocolor
1   Island Basic Land - Is...Urza's SagaLandnocolor
1   Island Basic Land - Is...Urza's SagaLandnocolor
1   Island Basic Land - Is...ZendikarLandnocolor
18   Island Basic Land - Is...Zendikar--Landnocolor