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 '84,83,81,80,79,78,6,5) AND (product.title LIKE '%%' OR product.articul LIKE '%%'' 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 '84,83,81,80,79,78,6,5) AND (product.title LIKE '%%' OR product.articul LIKE '%%'' 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: 3786603 Threads: 27 Questions: 10444951062 Slow queries: 1698 Opens: 198195342 Flush tables: 51 Open tables: 99999 Queries per second avg: 2758.396 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 162611013 [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 (,84,83,81,80,79,78,6,5) 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"