1054 - Unknown column 'p.products_id' in 'on 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, convert(pd.specs_15d, signed) as gallons, (pd.specs_7d + 0) as CFM, (pd.specs_6d + 0) as CFM2, p.products_box2, p.products_box3, p.products_type, pd.specs_2d, pd.specs_1d, 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, p.products_type, p.products_status1, p.products_quantity1, p.call_quote, p.sale_date, p.ship_method, p.expedited_shipping from products p left join manufacturers m using(manufacturers_id), product_features pf JOIN products_description pd using(products_id) left JOIN products_to_stores p2s using(products_id) left JOIN factory_closeout f using(products_id) left JOIN recommends r on r.products_id = p.products_id where p.products_status = '1' and p.products_id = pd.products_id and pf.products_id = p.products_id and p2s.stores_id = '1' and p.products_type < '5' and p.products_type > '0' and pf.feature_text like '%oil free%' order by new_product desc, p.recent_sales desc, pd.products_name asc
[TEP STOP]
|
We Ship To: 
