osCommerce My Account  Cart Contents  Checkout  
  Top » Catalog » Other » PreOrder OCT12  |  My Account  |  Cart Contents  |  Checkout | 
Shopping Cart more
0 items
Categories
Electro-Magnetic Press (6)
Kinetic Press (22)
WVPopCon (11)
Shipping & Add. books (28)
Supplies (Bags, etc)
Other->
  PreOrder OCT12->
    Diamond Publications
    Dark Horse Comics
    DC Comics
    DC Toys*Other
    IDW Publishing
    Image Comics
    Marvel Comics
    Marvel Posters
    Other Publishers A-C
    Other Publishers D-J
    Other Publishers K-R
    Other Publishers S-Z
    Books & Magazines
    Trading Cards
    Apparel
    Toys to Novelties
    Games
    DVDs & Digital Media
  PreOrder SEP12->
  PreOrder AUG12->
Pre-Orders
Publishers
What's New? more
Westward #7 (of 10)
Westward #7 (of 10)
$3.50
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
eBay Auctions
The Soap Box
About This Site
Contact Us
Shipping & Returns
Privacy Notice
Conditions of Use
Order Definitions
More Web Sites
Store Locations
Next Week's Books
Categories PreOrder OCT12
Diamond Publications
Diamond Publications
Dark Horse Comics
Dark Horse Comics
DC Comics
DC Comics
DC Toys*Other
DC Toys*Other
IDW Publishing
IDW Publishing
Image Comics
Image Comics
Marvel Comics
Marvel Comics
Marvel Posters
Marvel Posters
Other Publishers A-C
Other Publishers A-C
Other Publishers D-J
Other Publishers D-J
Other Publishers K-R
Other Publishers K-R
Other Publishers S-Z
Other Publishers S-Z
Books & Magazines
Books & Magazines
Trading Cards
Trading Cards
Apparel
Apparel
Toys to Novelties
Toys to Novelties
Games
Games
DVDs & Digital Media
DVDs & Digital Media
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c LEFT JOIN featured AS f ON p.products_id = f.products_id WHERE f.status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '152' and p.products_status = '1' order by p.products_date_added desc

[TEP STOP]