Fatal error: Uncaught Exception: 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 ')
GROUP BY op2.product_id
ORDER BY total DESC
LIMIT 4' at line 5<br />Error No: 1064<br />SELECT op2.product_id, COUNT(op2.product_id) AS total
FROM `oc_order_product` op1
JOIN `oc_order_product` op2 ON op1.order_id = op2.order_id AND op1.product_id != op2.product_id
JOIN `oc_order` o ON op1.order_id = o.order_id
WHERE op1.product_id = '11982' AND o.order_status_id > 0 AND op2.product_id NOT IN ()
GROUP BY op2.product_id
ORDER BY total DESC
LIMIT 4 in /var/www/www-root/data/www/gomeovet.ru/system/library/db/mysqli.php:48
Stack trace:
#0 /var/www/www-root/data/www/gomeovet.ru/system/library/db.php(45): DB\MySQLi->query('SELECT op2.prod...')
#1 /var/www/www-root/data/www/gomeovet.ru/storage/modification/catalog/model/catalog/product.php(1442): DB->query('SELECT op2.prod...')
#2 /var/www/www-root/data/www/gomeovet.ru/storag in /var/www/www-root/data/www/gomeovet.ru/system/library/db/mysqli.php on line 48