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.33-36-log [server_version] => 50733 [stat] => Uptime: 5105428 Threads: 35 Questions: 13008349154 Slow queries: 16703 Opens: 327791395 Flush tables: 60 Open tables: 100000 Queries per second avg: 2547.944 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 129343172 [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"