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=54671 or p.products_id=42220 or p.products_id=42217 or p.products_id=41975 or p.products_id=40841 or p.products_id=40334 or p.products_id=38462 or p.products_id=35042 or p.products_id=34262 or p.products_id=27941 or p.products_id=27155 or p.products_id=27150 or p.products_id=25910 or p.products_id=25873 or p.products_id=25828 or p.products_id=25204 or p.products_id=25201 or p.products_id=25183 or p.products_id=25169 or p.products_id=23560 or p.products_id=22715 or p.products_id=22708 or p.products_id=22242 or p.products_id=22196 or p.products_id=22171 or p.products_id=22128 or p.products_id=22059 or p.products_id=22058 or p.products_id=21939 or p.products_id=19367) AND pd.language_id = 1 ]