[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (3) Error writing file '/tmp/MYfd=2036' (OS errno 28 - No space left on device) (400)
SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.NAME as NAME,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.DETAIL_TEXT as DETAIL_TEXT,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL, FPEN0.VALUE as PROPERTY_RUB_MAIN_VALUE, FPEN0.ID as PROPERTY_RUB_MAIN_ENUM_ID, CONCAT(BE.ID, ':', 1183) as PROPERTY_RUB_MAIN_VALUE_ID,BE.ACTIVE_FROM as ACTIVE_FROM_X, case when EXTRACT(HOUR FROM BE.ACTIVE_FROM) > 0 OR EXTRACT(MINUTE FROM BE.ACTIVE_FROM) > 0 OR EXTRACT(SECOND FROM BE.ACTIVE_FROM) > 0 then DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s') else DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y') end as ACTIVE_FROM,L.DIR as LANG_DIR,BE.CODE as CODE,BE.XML_ID as EXTERNAL_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,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_s95 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = 1183 AND FPS0.PROPERTY_1183 = FPEN0.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 (68607)))
) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID
WHERE 1=1
AND (
((((BE.IBLOCK_ID = 95))))
AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL)))
AND ((((BE.ACTIVE='Y'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY BE.ACTIVE_FROM desc
LIMIT 99 OFFSET 1782
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/lib/db/mysqlcommonconnection.php:417
#0: Bitrix\Main\DB\MysqlCommonConnection->createQueryException(integer, string, string)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/database.php:683
#1: CAllDatabase->Query(string, boolean)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/dbresult.php:285
#2: CAllDBResult->NavQuery(string, string, array)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/iblock/classes/mysql/iblockelement.php:860
#3: CIBlockElement::GetList(array, array, boolean, array, array)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/components/bloknot/CIBlockElement.GetList/component.php:55
#4: include(string)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/component.php:622
#5: CBitrixComponent->__includeComponent()
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/component.php:699
#6: CBitrixComponent->includeComponent(string, array, boolean, boolean)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/main.php:1197
#7: CMain->IncludeComponent(string, string, array, boolean)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/templates/bloknot/components/bitrix/news/template/section.php:88
#8: include(string)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/component_template.php:842
#9: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/component_template.php:951
#10: CBitrixComponentTemplate->IncludeTemplate(array)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/component.php:791
#11: CBitrixComponent->showComponentTemplate()
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/component.php:731
#12: CBitrixComponent->includeComponentTemplate(string)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/components/bitrix/news/component.php:336
#13: include(string)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/component.php:622
#14: CBitrixComponent->__includeComponent()
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/component.php:699
#15: CBitrixComponent->includeComponent(string, array, NULL, boolean)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/classes/general/main.php:1197
#16: CMain->IncludeComponent(string, string, array)
/home/sites/demo.bloknot-volgodonsk.ru/www/news/index.php:113
#17: include_once(string)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/modules/main/include/urlrewrite.php:128
#18: include_once(string)
/home/sites/demo.bloknot-volgodonsk.ru/www/bitrix/urlrewrite.php:2
----------
