FILE: /home/ultrafilter/sites/ultrafilter.com.ua/bitrix/modules/iblock/classes/mysql/iblock.php LINE: 235 MySQL Query Error:
SELECT
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
,COUNT(DISTINCT BE.ID) as ELEMENT_CNT
FROM
b_iblock B
LEFT JOIN b_iblock_site BS ON B.ID=BS.IBLOCK_ID
LEFT JOIN b_lang L ON L.LID=BS.SITE_ID
LEFT JOIN b_iblock_element BE ON (BE.IBLOCK_ID=B.ID
AND (
(BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL )
)
)
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')
))
)
AND ((((BS.SITE_ID='s1')))) AND ((((B.ACTIVE='Y')))) AND ((((B.CODE LIKE 'yam-catalog'))))
GROUP BY B.ID
[[1021] Disk full (/tmp/#sql_7d9_1); waiting for someone to free some space...]
