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=20276 or p.products_id=20155 or p.products_id=13947 or p.products_id=13930 or p.products_id=13897 or p.products_id=13881 or p.products_id=13852 or p.products_id=13841 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=13756 or p.products_id=13753 or p.products_id=13751 or p.products_id=13744 or p.products_id=13738 or p.products_id=13677 or p.products_id=13671 or p.products_id=13665 or p.products_id=13657 or p.products_id=13648 or p.products_id=13051 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=12929 or p.products_id=12879 or p.products_id=12870 or p.products_id=12863 or p.products_id=12837 or p.products_id=12783 or p.products_id=12777 or p.products_id=12774 or p.products_id=12746 or p.products_id=12708 or p.products_id=12704 or p.products_id=12688 or p.products_id=12670 or p.products_id=12652 or p.products_id=12651 or p.products_id=12624 or p.products_id=12617 or p.products_id=12614 or p.products_id=12606) AND pd.language_id = 1 ]