Error: 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 ' 35, 36, 37, 38, 46, 39, 40, 91, 90, 92, 93, 47, 124, 95, 118, 49, 89, 96, 97, 9' at line 1
Error No: 1064
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_discount pdis ON p.product_id = pdis.product_id AND pdis.customer_group_id = '8' and pdis.quantity <= '1' AND pdis.date_start <= NOW() AND pdis.date_end >= NOW() LEFT JOIN product_special ps ON p.product_id = ps.product_id AND ps.customer_group_id = '8' AND ps.date_start <= NOW() AND ps.date_end >= NOW() LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p2s.store_id = '0' AND p.date_available <= NOW() AND IF(pdis.quantity, pdis.quantity, '1') = '1' AND LEAST(IF(p.price, p.price, 99999), IF(pdis.price, pdis.price, 99999), IF(ps.price, ps.price, 99999)) >= 900 AND p2c.category_id IN (, 35, 36, 37, 38, 46, 39, 40, 91, 90, 92, 93, 47, 124, 95, 118, 49, 89, 96, 97, 98, 108, 50, 112, 113, 114, 115, 51, 120, 101, 109, 110, 111, 52, 53, 125, 126, 102, 103, 104, 105, 106, 107, 54, 127, 116, 117, 41, 48, 55, 56, 57, 123, 43, 58, 60, 61)