MySQL Query Error:
SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_PICTURE as PREVIEW_PICTURE, FPS0.PROPERTY_54 as PROPERTY_LINK_VALUE, concat(BE.ID , ':' , 54) as PROPERTY_LINK_VALUE_ID,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE
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_element_prop_s10 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.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.ACTIVE = 'Y') AND (BS.GLOBAL_ACTIVE = 'Y') AND (BS.CODE IN ('TOP')))
) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID
WHERE 1=1
AND (
((((BE.IBLOCK_ID = '10'))))
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 (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY RAND(558816)
LIMIT 1
[[1021] Disk full (/tmp/#sql_da4_6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]