File: /var/www/sbproekt1ru/data/www/sb-proekt.ru/bitrix/modules/catalog/mysql/product.php
Line: 196
MySQL Query Error: SELECT CAT_CG.ID, CAT_CGL.NAME as CATALOG_GROUP_NAME, IF(CAT_CGG.ID IS NULL, 'N', 'Y') as CATALOG_CAN_ACCESS, IF(CAT_CGG1.ID IS NULL, 'N', 'Y') as CATALOG_CAN_BUY FROM b_catalog_group CAT_CG LEFT JOIN b_catalog_group2group CAT_CGG ON (CAT_CG.ID = CAT_CGG.CATALOG_GROUP_ID AND CAT_CGG.GROUP_ID IN (2) AND CAT_CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CAT_CGG1 ON (CAT_CG.ID = CAT_CGG1.CATALOG_GROUP_ID AND CAT_CGG1.GROUP_ID IN (2) AND CAT_CGG1.BUY = 'Y') LEFT JOIN b_catalog_group_lang CAT_CGL ON (CAT_CG.ID = CAT_CGL.CATALOG_GROUP_ID AND CAT_CGL.LID = 'ru') WHERE CAT_CG.ID IN (1,2,3,4,5,6,7,8,16,17,18) GROUP BY CAT_CG.ID [Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sb-proekt.CAT_CGG.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]