osCommerce My Account  Cart Contents  Checkout  
  Top » Catalog » Other  |  My Account  |  Cart Contents  |  Checkout | 
Shopping Cart more
0 items
Electro-Magnetic Press (6)
Kinetic Press (22)
WVPopCon (11)
Shipping & Add. books (28)
Supplies (Bags, etc)
  PreOrder OCT12->
  PreOrder SEP12->
  PreOrder AUG12->
What's New? more
Westward #8 (of 10) (Signed)
Westward #8 (of 10) (Signed)
Quick Find
Use keywords to find the product you are looking for.
Advanced Search
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 Other
PreOrder OCT12
PreOrder OCT12
PreOrder SEP12
PreOrder SEP12
PreOrder AUG12
PreOrder AUG12
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 = '98' and p.products_status = '1' order by p.products_date_added desc