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 (5479)))
) 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 ('368101', '368105', '368109', '368111', '368113', '369922', '369924', '369926', '369928', '375420', '375422', '375424', '398909', '405469', '406896', '406898', '411967', '414987', '416940', '425744', '425746', '425748', '425752'))))
)
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/MYfPTjKX' (Errcode: 28 - No space left on device)]
DB query error.
Please try later.
|
|
