You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))) AND ( enabled=1) ORDER BY `ordering_available` DESC, IF(in_stock>0,1,0) DES' at line 1
SELECT SQL_CALC_FOUND_ROWS p.*, name_ru AS _name_sort FROM SC_products p WHERE ( (p.productID IN ())) AND ( enabled=1) ORDER BY `ordering_available` DESC, IF(in_stock>0,1,0) DESC, sort_order, Price ASC, _name_sort LIMIT 0,30