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 'p.products_id, p.products_image, pd.products_name,m.manufacturers_id,manufacture' at line 1
in:
[SELECT (specials_new_products_price/p.products_price) as special_price_ritsu p.products_id, p.products_image, pd.products_name,m.manufacturers_id,manufacturers_name,p.manufacturers_id,p.master_categories_id,p.products_quantity,p.products_set_flg FROM (products p LEFT JOIN specials s on p.products_id = s.products_id LEFT JOIN products_description pd on p.products_id = pd.products_id LEFT JOIN manufacturers m on m.manufacturers_id = p.manufacturers_id ) WHERE p.products_id = pd.products_id and p.products_status = '1' AND pd.language_id = 1 ORDER BY s.specials_date_added DESC limit 0, 20]