logo Magic the Gathering, Yugioh, Pokemon, World of Warcraft CCG from a Professional UK Supplier
Psisoft Games
HOME    LOGIN    WHAT'S NEW?    a1 AUCTIONS    a4 FAVOURITE    a5 MAKE HOME   a6 SPECIALS    CONTACT US
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
a Categories b
bg1
Accessories->
Bargains
Board Games
Card Games->
Collectables->
Fantasy Novels->
Miniatures Games->
Other Games->
Role-playing Games->
View All Products ->
All Products sorted by Categories ->
All Products sorted by Manufacturers ->
bg2
c d
10th Edition Show:
Tenth Edition features 383 cards, including randomly inserted premium versions of all cards in the set. As a special celebration of this landmark tenth core set, plus Magic celebrating its 15th anniversary in 2008, Tenth Edition will be printed entirely in black borders! All Tenth Edition products in all languages will have black borders, which includes booster packs, theme decks, fat packs, and starter products.
a 10th Edition a
box_bg_l.gif.
Displaying 1 to 20 (of 530 products) Result Pages:  1  2  3  4  5  6  7  8  9  10 ...  [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 = '104431' and p.products_status = '1' order by limit 0, 20

[TEP STOP]