Лимониум

Название
8 16 32
0
В наличии
64.86 руб.
0
В наличии
95.88 руб.
0
В наличии
141.94 руб.
0
В наличии
104.34 руб.
0
Нет в наличии
99.64 руб.
0
Нет в наличии
61.10 руб.
0
Нет в наличии
85.26 руб.
File: /data/floraland.ru/bitrix/modules/sale/mysql/product.php
Line: 199
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 INNER JOIN b_sale_order O ON (b.ORDER_ID = O.ID) WHERE b.ORDER_ID is not null AND ( ( O.DATE_CANCELED >= '2020-01-05 00:00:00' AND O.CANCELED = 'Y' ) OR ( O.DATE_ALLOW_DELIVERY >= '2020-01-05 00:00:00' AND O.ALLOW_DELIVERY = 'Y' ) OR ( O.DATE_PAYED >= '2020-01-05 00:00:00' AND O.PAYED = 'Y' ) OR ( O.DATE_DEDUCTED >= '2020-01-05 00:00:00' AND O.DEDUCTED = 'Y' ) OR ( O.STATUS_ID = 'N' AND O.DATE_UPDATE >= '2020-01-05 00:00:00' ) OR ( O.STATUS_ID = 'P' AND O.DATE_UPDATE >= '2020-01-05 00:00:00' ) OR ( O.STATUS_ID = 'F' AND O.DATE_UPDATE >= '2020-01-05 00:00:00' ) ) GROUP BY b.PRODUCT_ID, ifnull(b.CATALOG_XML_ID, ''), b.PRODUCT_XML_ID, b.CURRENCY ORDER BY PRICE DESC LIMIT 4[[1055] Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bitrix.b.NAME' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]

DB query error.
Please try later.