lemi

File: /home/bitrix/www/bitrix/modules/catalog/mysql/price.php
Line: 141
MySQL Query Error: SELECT DISTINCT P.ID as ID, P.PRODUCT_ID as PRODUCT_ID, P.EXTRA_ID as EXTRA_ID, P.CATALOG_GROUP_ID as CATALOG_GROUP_ID, P.PRICE as PRICE, P.CURRENCY as CURRENCY, DATE_FORMAT(P.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, P.QUANTITY_FROM as QUANTITY_FROM, P.QUANTITY_TO as QUANTITY_TO, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as CATALOG_GROUP_NAME, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY FROM b_catalog_price P INNER JOIN b_catalog_group CG ON (P.CATALOG_GROUP_ID = CG.ID) LEFT JOIN b_catalog_group_lang CGL ON (P.CATALOG_GROUP_ID = CGL.CATALOG_GROUP_ID AND CGL.LANG = 'ru') LEFT JOIN b_catalog_group2group CGG ON (P.CATALOG_GROUP_ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (2) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (P.CATALOG_GROUP_ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (2) AND CGG1.BUY = 'Y') WHERE ((((P.CATALOG_GROUP_ID = 1 ))))[[0] ]

DB query error.
Please try later.