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=26044 or p.products_id=24266 or p.products_id=22486 or p.products_id=20922 or p.products_id=20550 or p.products_id=20527 or p.products_id=20510 or p.products_id=20462 or p.products_id=18818 or p.products_id=18104 or p.products_id=16620 or p.products_id=16410 or p.products_id=15286 or p.products_id=13161 or p.products_id=13108 or p.products_id=13094 or p.products_id=13082 or p.products_id=13026 or p.products_id=13023 or p.products_id=13013 or p.products_id=12944 or p.products_id=12942 or p.products_id=12881 or p.products_id=12846 or p.products_id=12833 or p.products_id=12771 or p.products_id=12155 or p.products_id=12120 or p.products_id=12117 or p.products_id=12019 or p.products_id=11932 or p.products_id=11881 or p.products_id=11840 or p.products_id=11673 or p.products_id=11529 or p.products_id=11382 or p.products_id=11246 or p.products_id=10512 or p.products_id=10498 or p.products_id=10456 or p.products_id=10336 or p.products_id=10283 or p.products_id=10259 or p.products_id=10257 or p.products_id=10176 or p.products_id=10173 or p.products_id=10170 or p.products_id=10167 or p.products_id=10152 or p.products_id=10125) AND pd.language_id = 1 ]