MySQL Ошибка!
MySQL ошибка в файле: /core/class/item.php строка 211
Номер ошибки: 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 '-30,30' at line 1
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 '-30,30' at line 1
SQL запрос:
SELECT STRAIGHT_JOIN * FROM `lib_items` LEFT JOIN `sync_category` ON lib_items.id = sync_category.item_id LEFT JOIN `sync_spec` ON lib_items.id = sync_spec.item_id WHERE (lib_items.temp_price BETWEEN 0 AND 183177) AND lib_items.temp_price > 0 AND lib_items.showhide > 0 AND lib_items.instock != 3 AND lib_items.fabric in ('8') GROUP BY lib_items.id order by lib_items.instock_num desc, FIELD(lib_items.instock, '1', '2', '0', '3'), lib_items.temp_price ASC LIMIT -30,30
SELECT STRAIGHT_JOIN * FROM `lib_items` LEFT JOIN `sync_category` ON lib_items.id = sync_category.item_id LEFT JOIN `sync_spec` ON lib_items.id = sync_spec.item_id WHERE (lib_items.temp_price BETWEEN 0 AND 183177) AND lib_items.temp_price > 0 AND lib_items.showhide > 0 AND lib_items.instock != 3 AND lib_items.fabric in ('8') GROUP BY lib_items.id order by lib_items.instock_num desc, FIELD(lib_items.instock, '1', '2', '0', '3'), lib_items.temp_price ASC LIMIT -30,30