Top » Catalog » Magic: the Gathering » Magic Vintage Singles » Core Set » Uncommon

My Account  |  Cart Contents  |  Checkout

Categories Duel Masters-> (748) Magic: the Gathering-> (8353)   Magic Standard Singles-> (1471)   Magic Extended Singles-> (4124)   Magic Vintage Singles-> (1196)     Core Set (322)     Scourge (130)     Legions (99)     Onslaught (257)     Judgment     Torment     Odyssey (210)     Apocalypse     Planeshift     Invasion (178)   Magic Legacy Singles-> (303)   Magic the Gathering Foils-> (1259)   Magic the Gathering Promotional Versus System-> (1967) World of Warcraft TCG-> (2445) Dreamblade-> (4) Panini Collectibles (1) Ultra Pro Products (17) Quick Find   Use keywords to find the product you are looking for. Advanced Search Information Payments & Shipping Contact Us

8E-117. Abyssal Specter [Uncommon] 0.15EUR If you want to know how this card looks like, click here. 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '141' and opa.orders_id = opb.orders_id and opb.products_id != '141' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6 [TEP STOP]