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 (5051)))
) 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 ('237474', '237547', '237556', '237557', '237558', '237559', '237560', '237561', '237562', '237563', '237588', '238148', '238745', '239096', '239101', '239102', '239111', '239173', '340573', '357461', '368233', '371415', '398981', '403562', '403564'))))
)
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/MYphy2lQ' (Errcode: 28 - No space left on device)]
DB query error.
Please try later.
|
|
