TETRA
File: /home/bitrix/web/air-pump.ru/public_html/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 INNER JOIN b_sale_order O ON (b.ORDER_ID = O.ID) WHERE b.ORDER_ID is not null AND ( ( O.DATE_CANCELED >= '2026-04-27 00:00:00' AND O.CANCELED = 'Y' ) OR ( O.DATE_ALLOW_DELIVERY >= '2026-04-27 00:00:00' AND O.ALLOW_DELIVERY = 'Y' ) OR ( O.DATE_PAYED >= '2026-04-27 00:00:00' AND O.PAYED = 'Y' ) OR ( O.DATE_DEDUCTED >= '2026-04-27 00:00:00' AND O.DEDUCTED = 'Y' ) OR ( O.STATUS_ID = 'N' AND O.DATE_UPDATE >= '2026-04-27 00:00:00' ) OR ( O.STATUS_ID = 'P' AND O.DATE_UPDATE >= '2026-04-27 00:00:00' ) OR ( O.STATUS_ID = 'F' AND O.DATE_UPDATE >= '2026-04-27 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 4[[2006] MySQL server has gone away]
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 INNER JOIN b_sale_order O ON (b.ORDER_ID = O.ID) WHERE b.ORDER_ID is not null AND ( ( O.DATE_CANCELED >= '2026-04-27 00:00:00' AND O.CANCELED = 'Y' ) OR ( O.DATE_ALLOW_DELIVERY >= '2026-04-27 00:00:00' AND O.ALLOW_DELIVERY = 'Y' ) OR ( O.DATE_PAYED >= '2026-04-27 00:00:00' AND O.PAYED = 'Y' ) OR ( O.DATE_DEDUCTED >= '2026-04-27 00:00:00' AND O.DEDUCTED = 'Y' ) OR ( O.STATUS_ID = 'N' AND O.DATE_UPDATE >= '2026-04-27 00:00:00' ) OR ( O.STATUS_ID = 'P' AND O.DATE_UPDATE >= '2026-04-27 00:00:00' ) OR ( O.STATUS_ID = 'F' AND O.DATE_UPDATE >= '2026-04-27 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 4[[2006] MySQL server has gone away]
|