File: /home/bitrix/ext_www/vkuhnu.ru/bitrix/modules/sale/mysql/product.php
Line: 200
MySQL Query Error: SELECT b.PRODUCT_ID, b.NAME, ifnull(b.CATALOG_XML_ID, '') CATALOG_XML_ID, b.PRODUCT_XML_ID, SUM(b.PRICE*b.QUANTITY) as PRICE, AVG(b.PRICE) as AVG_PRICE, SUM(b.QUANTITY) as QUANTITY, b.CURRENCY FROM b_sale_basket b LEFT JOIN b_sale_basket_props p1 ON (b.ID = p1.BASKET_ID) INNER JOIN b_sale_order O ON (b.ORDER_ID = O.ID) WHERE b.ORDER_ID is not null AND p1.CODE = 'PRODUCT.XML_ID' AND p1.VALUE NOT IN ) AND O.CANCELED = 'N' AND O.DATE_INSERT >= '2021-02-05 00:00:00' GROUP BY b.PRODUCT_ID, b.NAME, ifnull(b.CATALOG_XML_ID, ''), b.PRODUCT_XML_ID, b.CURRENCY ORDER BY PRICE DESC LIMIT 200[[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 ') AND O.CANCELED = 'N' AND O.DATE_INSERT >= '2021-02-05 00:00:00' GROUP BY b.' at line 7]

DB query error.
Please try later.