Clean Happens is based in St. Louis, MO, and is dedicated to making safe, green cleaning products that are "the safest, most powerful, and genuinely green household cleaning products on the planet."
Displaying 1 to 4 (of 4 products)
Result Pages: 1
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 20' at line 1
select p.cf,p.ef,p.lf,p.sf,p.pf,p.org,p.kos,p.glf,p.frozen,p.sugfr,p.nutfree,p.amounts,p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, 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 p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '222' order by limit 0, 20