–Каталог–Line: 364
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, CG.XML_ID as XML_ID, 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') WHERE ((((CG.NAME = 'Цена 5 (розница)' )))) GROUP BY CG.ID, CG.NAME, CG.BASE, CG.SORT, CG.XML_ID, CGL.NAME [Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'stalkerk_base.CGG.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
|