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=37770 or p.products_id=37188 or p.products_id=37151 or p.products_id=19078 or p.products_id=11923 or p.products_id=11461 or p.products_id=11413 or p.products_id=10422 or p.products_id=6276 or p.products_id=6268 or p.products_id=6261 or p.products_id=6250 or p.products_id=6245 or p.products_id=6232 or p.products_id=6224 or p.products_id=6222 or p.products_id=6219 or p.products_id=6212 or p.products_id=6202 or p.products_id=6178 or p.products_id=6170 or p.products_id=6158 or p.products_id=6152 or p.products_id=6142 or p.products_id=6119 or p.products_id=6111 or p.products_id=6092 or p.products_id=6082 or p.products_id=6080 or p.products_id=6077) AND pd.language_id = 1 ]