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 ') ORDER BY price_sort DESC, Price ASC, sort_order, _name_sort LIMIT 0,9' at line 1
SELECT SQL_CALC_FOUND_ROWS p.*, p.name_ru AS _name_sort, IF(p.Price ="0", 0, 1) as price_sort FROM SC_products p WHERE enabled=1 AND `p`.`productID` IN() ORDER BY price_sort DESC, Price ASC, sort_order, _name_sort LIMIT 0,9