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 ('208433', '210205', '201013', '211237', '210374', '163300', '204012', '214920', '220416', '208423', '208425', '220456', '208290', '208413', '204586', '208404', '199781', '214921', '208431', '211238', '210459', '210284', '211199', '204139', '210286'))))
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/MYu4y3TA' (Errcode: 28 - No space left on device)] MySQL Query Error!