MySQL Query Error:
SELECT
BE.ID IBLOCK_ELEMENT_ID
,BEP.IBLOCK_PROPERTY_ID
,BEP.VALUE
,BEP.VALUE_NUM
FROM
b_iblock B
INNER JOIN b_lang L ON B.LID=L.LID
INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
INNER JOIN (
SELECT DISTINCT BSE.IBLOCK_ELEMENT_ID
FROM b_iblock_section_element BSE
INNER JOIN b_iblock_section BS ON BSE.IBLOCK_SECTION_ID = BS.ID
WHERE ((BS.ID IN (5451)))
) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1
AND (
((((BE.IBLOCK_ID = '4'))))
AND ((((BE.ACTIVE='Y'))))
AND (((BE.ID IN ('108729', '108730', '108731', '108732', '108733', '108735', '108736', '109021', '109022', '109128', '109129', '109130', '109131', '109132', '109134', '109135', '109177', '278770', '278772', '278773', '278774', '278775', '278776', '278777', '278778', '278779', '278780', '278781', '278782', '278783', '278784', '278785', '278787', '278788', '278789', '288906', '296098', '309813', '309814', '309815', '309816', '378575', '378577', '378579', '378581', '378585', '378597', '384966', '384968', '384970', '402283', '402383', '402385', '402387', '402389', '402391', '405333', '405337', '408671'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY
BEP.IBLOCK_ELEMENT_ID, BEP.IBLOCK_PROPERTY_ID, BEP.ID
[[3] Error writing file '/tmp/MYjbP3t8' (Errcode: 28 - No space left on device)]
DB query error.
Please try later.
|
|
