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=21845 or p.products_id=21843 or p.products_id=21680 or p.products_id=21227 or p.products_id=20281 or p.products_id=20280 or p.products_id=20279 or p.products_id=20276 or p.products_id=20167 or p.products_id=20166 or p.products_id=20155 or p.products_id=20124 or p.products_id=13947 or p.products_id=13930 or p.products_id=13897 or p.products_id=13885 or p.products_id=13881 or p.products_id=13852 or p.products_id=13841 or p.products_id=13838 or p.products_id=13821 or p.products_id=13814 or p.products_id=13807 or p.products_id=13785 or p.products_id=13781 or p.products_id=13779 or p.products_id=13774 or p.products_id=13769 or p.products_id=13763 or p.products_id=13756 or p.products_id=13753 or p.products_id=13751 or p.products_id=13744 or p.products_id=13739 or p.products_id=13738 or p.products_id=13692 or p.products_id=13677 or p.products_id=13671 or p.products_id=13665 or p.products_id=13660 or p.products_id=13657 or p.products_id=13648 or p.products_id=13051 or p.products_id=13045 or p.products_id=13031 or p.products_id=13029 or p.products_id=13024 or p.products_id=13015 or p.products_id=12984 or p.products_id=12978) AND pd.language_id = 1 ]