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
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
Magic the Gathering->
|__Dragon's Maze
|__Gatecrash
|__Magic 2013
|__Return to Ravnica
|__Avacyn Restored
|__Dark Ascenscion
|__Innistrad
|__10th Edition
|__4th Edition
|__5th Edition
|__6x9 Cards
|__7th Edition
|__8th Edition
|__9th Edition
|__Alara Reborn
|__Alliances
|__Alpha
|__Antiquities
|__Apocalypse
|__Arabian Nights
|__Beta
|__Betrayers/Kamigawa
|__Champions/Kamigawa
|__Chronicles
|__Classic (6th)
|__Coldsnap
|__Conflux
|__Dark Steel
|__Dissension
|__Eventide
|__Exodus
|__Fallen Empires
|__Fifth Dawn
|__Future Sight
|__Guildpact
|__Homelands
|__Ice Age
|__Invasion
|__Judgement
|__Legends
|__Legions
|__Lorwyn
|__Magic 2010 (11th Edition)
|__Magic 2011
|__Magic 2012
|__Merc. Masques
|__Mirage
|__Mirrodin
|__Mirrodin Besieged
|__Morningtide
|__Nemesis
|__New Phyrexia
|__Odyssey
|__Onslaught
|__Planar Chaos
|__Planeshift
|__Playmats
|__Portal
|__Portal: Second Age
|__Portal:3 Kingdoms
|__Promo
|__Prophecy
|__Ravnica City of Guilds
|__Revised
|__Rise of Eldrazi
|__Saviors/Kamigawa
|__Scars of Mirrodin
|__Scourge
|__Shadowmoor
|__Shards of Alara
|__Starter
|__Stronghold
|__Tempest
|__The Dark
|__Time Spiral
|__Torment
|__Unglued
|__Unhinged
|__Unlimited
|__Urzas Destiny
|__Urzas Legacy
|__Urzas Saga
|__Visions
|__Weatherlight
|__Worldwake
|__Zendikar
Pokemon TCG->
YuGiOh->
Accessories
Board Games
Other Card Games->
Bargains
Miniatures Games->
View All Products ->
All Products sorted by Categories ->
All Products sorted by Manufacturers ->
bg2
c d
4th Edition Show:
a 4th Edition a
box_bg_l.gif.
Displaying 151 to 200 (of 335 products) Result Pages: [<< Prev]   1  2  3  4  5  6  7  [Next >>] 
Checkout
1064 - You have an error in your SQL syntax near 'limit 150, 50' 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 = '136' and p.products_status = '1' order by limit 150, 50

[TEP STOP]