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 ') AND pd.language_id = 1' at line 5
in:
[select count(*) as total FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id or p.products_id=38157 or p.products_id=38123 or p.products_id=37077 or p.products_id=36894 or p.products_id=36097 or p.products_id=32723 or p.products_id=27791 or p.products_id=27267 or p.products_id=27265 or p.products_id=27257 or p.products_id=27245 or p.products_id=27048 or p.products_id=27043 or p.products_id=26351 or p.products_id=26350 or p.products_id=26349 or p.products_id=26348 or p.products_id=26347 or p.products_id=26346 or p.products_id=26345 or p.products_id=26344 or p.products_id=26342 or p.products_id=26341 or p.products_id=26340 or p.products_id=26339 or p.products_id=26338 or p.products_id=26337 or p.products_id=26335 or p.products_id=26333 or p.products_id=26332) AND pd.language_id = 1 ]