1054 - Unknown column 'new_product' in 'order clause'
SELECT p.products_model, p.products_image, m.manufacturers_id, p.products_id, pd.products_name, p.canada_shipping, p.products_price, p.products_extra_discount, p.products_retail_price, p.products_tax_class_id, p.products_weight, p.products_ordered, if(f.factory_closeout_id != 'NULL', true, false) as factory_exists, if(r.recommends_id != 'NULL', true, false) as recommends_exists, r.recommends_id, r.recommends_text, pd.specs_3d, p.products_box1, p.products_box2, p.products_box3, pd.extra_specs, p.products_type, p.products_status1, p.products_quantity1, p.call_quote from products p left join manufacturers m using(manufacturers_id) JOIN products_description pd left JOIN products_to_stores p2s on p.products_id = p2s.products_id left JOIN factory_closeout f on p.products_id = f.products_id left JOIN recommends r on r.products_id = p.products_id, featured feat where p.products_status = '1' and p.products_id = pd.products_id and p.products_id = feat.products_id and p2s.stores_id = '1' and feat.stores_id = '1' order by new_product desc, p.recent_sales desc, pd.products_name asc
[TEP STOP]
|
We Ship To: 
