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=42029 or p.products_id=27114 or p.products_id=27113 or p.products_id=24000 or p.products_id=23997 or p.products_id=23776 or p.products_id=20032 or p.products_id=15247 or p.products_id=13479 or p.products_id=12734 or p.products_id=12711 or p.products_id=12660 or p.products_id=12565 or p.products_id=12505 or p.products_id=10527 or p.products_id=10476 or p.products_id=10468 or p.products_id=10404 or p.products_id=10398 or p.products_id=10064 or p.products_id=9905 or p.products_id=9620 or p.products_id=9603 or p.products_id=9507 or p.products_id=9474 or p.products_id=9451 or p.products_id=9320 or p.products_id=9288 or p.products_id=9284 or p.products_id=9214 or p.products_id=9205 or p.products_id=9160 or p.products_id=9049 or p.products_id=9031 or p.products_id=8986 or p.products_id=8983 or p.products_id=8982 or p.products_id=8969 or p.products_id=8968 or p.products_id=8967 or p.products_id=8959 or p.products_id=8958 or p.products_id=8947 or p.products_id=8929 or p.products_id=8498 or p.products_id=8488 or p.products_id=8450 or p.products_id=8443 or p.products_id=8442 or p.products_id=8392) AND pd.language_id = 1 ]