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 ') AS p' at line 1
[select count(distinct p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join rebate_zone_products rz on rz.products_id=p2c.products_id and rz.rebate_expires >= '2024-03-04' left join bmg_products as b on b.products_id = p2c.products_id where p.products_status = 1 AND p.products_availability in (0,1,2,5,6) and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and 1=0 AND p.manufacturers_id = 865 order by warranty_sort, bmg_sort, p.products_date_added desc, m.manufacturers_name, p.products_model, p.cartridge_type_id LIMIT 600) AS p]