FILE: /sites/uspeh-1.rf/bitrix/modules/iblock/classes/mysql/iblocksection.php LINE: 302 MySQL Query Error:
SELECT DISTINCT
BS.ID AS ID,
BS.DEPTH_LEVEL AS DEPTH_LEVEL,
BS.NAME AS NAME,
B.SECTION_PAGE_URL AS SECTION_PAGE_URL,
BS.CODE AS CODE,
BS.XML_ID AS EXTERNAL_ID,
B.IBLOCK_TYPE_ID AS IBLOCK_TYPE_ID,
BS.IBLOCK_ID AS IBLOCK_ID,
B.CODE AS IBLOCK_CODE,
B.XML_ID AS IBLOCK_EXTERNAL_ID,
BS.GLOBAL_ACTIVE AS GLOBAL_ACTIVE
FROM b_iblock_section BS
INNER JOIN b_iblock B ON BS.IBLOCK_ID = B.ID
LEFT JOIN b_iblock_group IBG ON IBG.IBLOCK_ID=B.ID
WHERE 1=1
AND ((((BS.IBLOCK_ID = '6'))))
AND ((((BS.GLOBAL_ACTIVE='Y'))))
AND ((((BS.DEPTH_LEVEL <= '3'))))
AND ((((B.ID = '6'))))
AND ((((B.ACTIVE='Y'))))
AND (
IBG.GROUP_ID IN (2)
AND IBG.PERMISSION >= 'R'
AND (IBG.PERMISSION = 'X' OR B.ACTIVE = 'Y')
)
ORDER BY BS.LEFT_MARGIN asc [Expression #1 of ORDER BY clause is not in SELECT list, references column 'uspeh_db.BS.LEFT_MARGIN' which is not in SELECT list; this is incompatible with DISTINCT]