MySQL Query Error:
SELECT
BE.ID IBLOCK_ELEMENT_ID
,BEP.IBLOCK_PROPERTY_ID
,BEP.VALUE
,BEP.VALUE_NUM
,BEP.ID PROPERTY_VALUE_ID
,BEP.DESCRIPTION
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 b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.ID=100
INNER JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
left join b_catalog_product as PRD on (PRD.ID = BE.ID)
LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1
AND (
((((BE.IBLOCK_ID = '26'))))
AND ((((BE.ACTIVE='Y'))))
AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL)))
AND (((FPV0.VALUE_NUM IN ('213543', '211092', '211231', '221343', '213541', '221751', '211240', '204330', '220421', '220427', '221746', '204064', '220425', '211229', '211234', '210364', '220423', '220399', '213426', '213060', '210366', '220419', '213066', '213067', '221745'))))
AND ((((PRD.AVAILABLE='Y'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) AND BEP.IBLOCK_PROPERTY_ID IN (100, 116, 756, 757, 758, 759, 760, 972, 974, 1028, 1031, 1032, 1033, 1034, 1035, 1114, 1115, 1116, 1120, 1122, 1839, 1840, 1858, 1859, 1865)
ORDER BY
BEP.IBLOCK_ELEMENT_ID, BEP.IBLOCK_PROPERTY_ID, BEP.ID
[[1] Can't create/write to file '/tmp/MY8sofXD' (Errcode: 28 - No space left on device)] MySQL Query Error!