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=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 or p.products_id=26331 or p.products_id=26330 or p.products_id=26329 or p.products_id=26328 or p.products_id=26221 or p.products_id=26216 or p.products_id=26100 or p.products_id=26095 or p.products_id=25628 or p.products_id=25627 or p.products_id=25620 or p.products_id=25598 or p.products_id=25594) AND pd.language_id = 1 ]