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=42307 or p.products_id=42017 or p.products_id=41609 or p.products_id=41333 or p.products_id=40223 or p.products_id=40195 or p.products_id=38157 or p.products_id=38123 or p.products_id=37785 or p.products_id=37569 or p.products_id=37151 or p.products_id=37142 or p.products_id=37077 or p.products_id=37075 or p.products_id=37007 or p.products_id=36894 or p.products_id=36786 or p.products_id=36634 or p.products_id=36395 or p.products_id=36097 or p.products_id=35818 or p.products_id=33310 or p.products_id=32723 or p.products_id=27791 or p.products_id=27267 or p.products_id=27265 or p.products_id=27260 or p.products_id=27257 or p.products_id=27245 or p.products_id=27048) AND pd.language_id = 1 ]