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 = 246 GROUP BY p.plyrcard_cid ORDER BY s.set_name ASC, c.card_name ASCMatches in km0n3y's Collection
(3 results found, 47 total cards)
Sort Order:
Num
| Name
| Type
| Set
| Cost
| P/T
| Rarity
| Color
| ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 
Island
| Basic Land - Is... | Lorwyn | Land | nocolor | ||||||||||||||||||||||||||||||||||
| 20 |
Island
| Basic Land - Is... | Magic 2010 | Land | nocolor | ||||||||||||||||||||||||||||||||||
| 17 |
Island
| Basic Land - Is... | Tenth Edition | Land | nocolor |
