logo Magic the Gathering, Gathering Yugioh, and Pokemon cards from a Professional UK Supplier
Psisoft Games
HOME    LOGIN    SHOPPING CART    WHAT'S NEW?    a4 FAVOURITE    a6 SPECIALS    CONTACT US

Warning: tep_cache_categories_box(includes/boxes/categories.php): failed to open stream: No such file or directory in /apps/webgod/livesite/includes/functions/cache.php on line 105

Warning: tep_cache_categories_box(): Failed opening 'includes/boxes/categories.php' for inclusion (include_path='.:/usr/share/pear') in /apps/webgod/livesite/includes/functions/cache.php on line 105
a Quick Find b
bg1
 
Show Stock Outs.
Ability Search.
Use keywords to find the product you are looking for.
Advanced Search
bg2
c d
Phantom Darkness Show:
The darkness awaits you as every aspect of the Yu-Gi-Oh! Trading Card Game plunges into dark with the release of Phantom Darkness. From the abyss, new villainous versions of many fan favourite monsters arrive to support and update many Deck types. Phantom Darkness is the largest set since 2004 and includes 10 cards exclusive to Upper Deck and 10 cards previously only released in Japan.
a Phantom Darkness a
box_bg_l.gif.
Displaying 1 to 20 (of 79 products) Result Pages:  1  2  3  4  [Next >>] 
Checkout
1064 - You have an error in your SQL syntax near 'limit 0, 20' at line 1

select p.products_image, pd.products_name, p.products_rarity, p.products_edition, p.products_quantity, p.products_id, p.products_status, p.manufacturers_id, p.products_price, e.edition_name, r.rarity_desc, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join psi_rarities r on p.products_rarity = r.rarity left join psi_editions e on e.edition_abb = p.products_edition left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '104455' and p.products_status = '1' order by limit 0, 20

[TEP STOP]