FILE: /var/www/www-root/data/www/centropttorg.ru/bitrix/modules/iblock/classes/mysql/iblock.php LINE: 218 MySQL Query Error:
SELECT DISTINCT
B.*
,B.XML_ID as EXTERNAL_ID
,DATE_FORMAT(B.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X
,L.DIR as LANG_DIR
,L.SERVER_NAME
FROM
b_iblock B
INNER JOIN b_lang L ON L.LID=B.LID
WHERE 1 = 1
AND (
B.ID IN (
SELECT IBLOCK_ID
FROM b_iblock_group IBG
WHERE IBG.GROUP_ID IN (2)
AND IBG.PERMISSION >= 'R'
AND (IBG.PERMISSION='X' OR B.ACTIVE='Y')
)
OR (B.RIGHTS_MODE = 'E' AND B.ID IN (
SELECT IBLOCK_ID
FROM b_iblock_right IBR
INNER JOIN b_task_operation T ON T.TASK_ID = IBR.TASK_ID
INNER JOIN b_operation O ON O.ID = T.OPERATION_ID
INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0
WHERE IBR.ENTITY_TYPE = 'iblock'
AND O.NAME in ('section_read', 'element_read', 'section_element_bind', 'section_section_bind')
))
)
ORDER BY B.SORT asc , B.NAME asc [[2013] Lost connection to MySQL server during query]