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
Coldsnap Show:
The Recently discovered legendary Lost Third Set of the Ice Age Block "Coldsnap" will feature 155 all New Cards (65 commons, 50 uncommons, and 40 rares). The card wordings will all be updated to work with current Magic rules (no "interrupts") and will include such modern niceties as expansion symbols color-coded by rarity, collector numbers, and foils. The set becomes legal for Standard constructed tournaments on August 20th 2006.

Available in boosters, theme decks, and a Fat Pack for this release. Since this is the third set of the Ice Age block, the theme decks will include a few cards from the first two sets of the block. For those cards Magic will be updating them to the new card frames (since Coldsnap uses the new card frames), but will be keeping their original art.
a Coldsnap a
box_bg_l.gif.
Displaying 1 to 20 (of 246 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 = '104377' and p.products_status = '1' order by limit 0, 20

[TEP STOP]