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=21428 or p.products_id=21243 or p.products_id=20922 or p.products_id=20571 or p.products_id=20550 or p.products_id=20537 or p.products_id=20535 or p.products_id=20527 or p.products_id=20510 or p.products_id=20462 or p.products_id=20091 or p.products_id=18818 or p.products_id=18104 or p.products_id=18091 or p.products_id=16620 or p.products_id=16410 or p.products_id=15389 or p.products_id=15286 or p.products_id=13161 or p.products_id=13135 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=12958 or p.products_id=12956 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=12092 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=11647 or p.products_id=11634 or p.products_id=11529 or p.products_id=11491) AND pd.language_id = 1 ]