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

Matches in renophaston's Collection

(15 results found, 36 total cards)

Sort Order:

Num

Name

Type

Set

Cost

P/T

Rarity

Color

Card Name:
Card Type:
Card Text:
Card Flavor:
Artist:
Set:
Rarity:
Cost Colors:	strict color search (narrower results)