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-08 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-08 00:00:00'
GROUP BY b.' at line 7]
DB query error.
Please try later.
|
|