File: /var/www/sbproekt1ru/data/www/sb-proekt.ru/bitrix/modules/catalog/mysql/cataloggroup.php
Line: 263
MySQL Query Error: SELECT CG.ID as ID, CG.NAME as NAME, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as NAME_LANG, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY, COUNT( CG.ID) as CNT FROM b_catalog_group CG LEFT JOIN b_catalog_group_lang CGL ON (CG.ID = CGL.CATALOG_GROUP_ID AND CGL.LID = 'ru') LEFT JOIN b_catalog_group2group CGG ON (CG.ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (2) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (2) AND CGG1.BUY = 'Y') GROUP BY CG.ID, CG.NAME, CG.BASE, CG.SORT, CGL.NAME [Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sb-proekt.CGG.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]