MySQL Query Error:
SELECT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID,BE.ACTIVE as ACTIVE,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as DATE_ACTIVE_FROM, FPS0.PROPERTY_103 as PROPERTY_STRIP_PICTURES_VALUE, FPS0.DESCRIPTION_103 as PROPERTY_STRIP_PICTURES_DESCRIPTION, FPS0.PROPERTY_130 as PROPERTY_THROUGH_NUMBER_VALUE, concat(BE.ID , ':' , 130) as PROPERTY_THROUGH_NUMBER_VALUE_ID, FPS0.PROPERTY_203 as PROPERTY_UNTHROUGH_NUMBER_VALUE, concat(BE.ID , ':' , 203) as PROPERTY_UNTHROUGH_NUMBER_VALUE_ID, FPS0.PROPERTY_210 as PROPERTY_PDF_EDITION_VALUE, concat(BE.ID , ':' , 210) as PROPERTY_PDF_EDITION_VALUE_ID,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as ACTIVE_FROM
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_s29 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
WHERE 1=1
AND (
((((BE.IBLOCK_ID = '29'))))
AND ((((BE.ACTIVE='Y'))))
AND ((((BE.ACTIVE_FROM <= '2025-12-18 22:08:03'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY BE.ACTIVE_FROM desc ,FPS0.PROPERTY_130 desc
LIMIT 324, 12[[3] Error writing file '/tmp/MYM1UdGe' (Errcode: 28 - No space left on device)]
DB query error.
Please try later.
|
|