mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ [client_version] => 50011 [connect_errno] => 0 [connect_error] => [errno] => 1064 [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 '86,85) AND (product.title LIKE '%%' OR product.articul LIKE '%%') AND product.mo' at line 5 [error_list] => Array ( [0] => Array ( [errno] => 1064 [sqlstate] => 42000 [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 '86,85) AND (product.title LIKE '%%' OR product.articul LIKE '%%') AND product.mo' at line 5 ) ) [field_count] => 14 [host_info] => bv259884.mysql.tools via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.7.43-47-log [server_version] => 50743 [stat] => Uptime: 4581841 Threads: 43 Questions: 12812468035 Slow queries: 2446 Opens: 239252481 Flush tables: 61 Open tables: 100000 Queries per second avg: 2796.358 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 195690539 [warning_count] => 0 )
Ошибка при запросе к базе: "SELECT product.*,FORMAT(SUM(s.point)/COUNT(s.point),2) as avr,COUNT(DISTINCT com.id) as total_com FROM product LEFT JOIN points as s ON s.prod_id=product.id LEFT JOIN comments as com ON com.prod_id=product.id AND com.status=1 WHERE product.subcat_id IN (,86,85) AND (product.title LIKE '%%' OR product.articul LIKE '%%') AND product.moder = '1' AND product.price > 0 GROUP BY product.id ORDER BY product.sort DESC, product.id DESC"