Magic the Gathering Advanced Card Search
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 = 794 GROUP BY p.plyrcard_cid ORDER BY s.set_name ASC, c.card_name ASCMatches in Ricowan's Collection
(3 results found, 6 total cards)
Sort Order:
Num
| Name
| Type
| Set
| Cost
| P/T
| Rarity
| Color
| ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 
Island
| Basic Land - Is... | Mirrodin Besieged | Land | nocolor | ||||||||||||||||||||||||||||||||||
| 1 |
Island
| Basic Land - Is... | New Phyrexia | Land | nocolor | ||||||||||||||||||||||||||||||||||
| 4 |
Island
| Basic Land - Is... | Scars of Mirrodin | Land | nocolor |
