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
Zane Truesdale Show:
Create the Deck based on everyone's favorite Yu-Gi-Oh! GX animates series character Zane Truesdale. Zane's "Cyber Dragon" has the standard in Deck creation in the current format. Wield the power of Zane's favorite cards or just collect his Deck and "Get your Game on!" New cards in Zane Truesdale Duelist Packs never seen before outside of the cartoon.
a Zane Truesdale a
box_bg_l.gif.
Displaying 1 to 20 (of 22 products) Result Pages:  1  2  [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 = '104425' and p.products_status = '1' order by limit 0, 20

[TEP STOP]