FILE: /srv/gorod-les.ru/www/bitrix/modules/iblock/classes/mysql/iblockelement.php
LINE: 782
MySQL Query Error: SELECT BE.NAME as NAME,BE.ID as ID,BE.ACTIVE as ACTIVE, FPV1.VALUE as PROPERTY_ACTION_ID_VALUE, FPEN0.VALUE as PROPERTY_NO_ACTION_TIME_VALUE, FPEN0.ID as PROPERTY_NO_ACTION_TIME_ENUM_ID, FPV3.VALUE as PROPERTY_FLAT_ID_VALUE, FPV0.VALUE as PROPERTY_IMPORTANT_VALUE, FPV4.VALUE as PROPERTY_FLAT_IMG_VALUE, FPEN1.VALUE as PROPERTY_FLAT_MUTE_ACTION_VALUE, FPEN1.ID as PROPERTY_FLAT_MUTE_ACTION_ENUM_ID, FPV6.VALUE as PROPERTY_HM_LINK_VIEW_VALUE, FPV7.VALUE as PROPERTY_HM_LINK_VALUE, FPV8.VALUE as PROPERTY_HM_IMG_VALUE, FPV9.VALUE as PROPERTY_HF_LINK_VALUE, FPV10.VALUE as PROPERTY_HF_IMG_VALUE, FPV11.VALUE as PROPERTY_HF_CODE_VALUE, FPV12.VALUE as PROPERTY_HF_IMG_TAB_VALUE, FPV13.VALUE as PROPERTY_HF_IMG_MOB_VALUE, FPV14.VALUE as PROPERTY_FT_LINK_VALUE, FPV15.VALUE as PROPERTY_FT_IMG_VALUE, FPV16.VALUE as PROPERTY_FT_CODE_VALUE, FPV17.VALUE as PROPERTY_FTL_LINK_VALUE, FPV18.VALUE as PROPERTY_FTL_IMG_VALUE, FPV19.VALUE as PROPERTY_FTL_IMG_TAB_VALUE, FPV20.VALUE as PROPERTY_FTL_CODE_VALUE, FPV21.VALUE as PROPERTY_HTL_LINK_VALUE, FPV22.VALUE as PROPERTY_HTL_CODE_VALUE, FPV23.VALUE as PROPERTY_HN_LINK_VALUE, FPV24.VALUE as PROPERTY_HN_IMG_VALUE, FPV25.VALUE as PROPERTY_HN_IMG_TAB_VALUE, COUNT(DISTINCT BE.ID) as CNT 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 LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='IMPORTANT' LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='ACTION_ID' LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='NO_ACTION_TIME' LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='FLAT_ID' LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.CODE='FLAT_IMG' LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.CODE='FLAT_MUTE_ACTION' LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND FP6.CODE='HM_LINK_VIEW' LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND FP7.CODE='HM_LINK' LEFT JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND FP8.CODE='HM_IMG' LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND FP9.CODE='HF_LINK' LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND FP10.CODE='HF_IMG' LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID = B.ID AND FP11.CODE='HF_CODE' LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID = B.ID AND FP12.CODE='HF_IMG_TAB' LEFT JOIN b_iblock_property FP13 ON FP13.IBLOCK_ID = B.ID AND FP13.CODE='HF_IMG_MOB' LEFT JOIN b_iblock_property FP14 ON FP14.IBLOCK_ID = B.ID AND FP14.CODE='FT_LINK' LEFT JOIN b_iblock_property FP15 ON FP15.IBLOCK_ID = B.ID AND FP15.CODE='FT_IMG' LEFT JOIN b_iblock_property FP16 ON FP16.IBLOCK_ID = B.ID AND FP16.CODE='FT_CODE' LEFT JOIN b_iblock_property FP17 ON FP17.IBLOCK_ID = B.ID AND FP17.CODE='FTL_LINK' LEFT JOIN b_iblock_property FP18 ON FP18.IBLOCK_ID = B.ID AND FP18.CODE='FTL_IMG' LEFT JOIN b_iblock_property FP19 ON FP19.IBLOCK_ID = B.ID AND FP19.CODE='FTL_IMG_TAB' LEFT JOIN b_iblock_property FP20 ON FP20.IBLOCK_ID = B.ID AND FP20.CODE='FTL_CODE' LEFT JOIN b_iblock_property FP21 ON FP21.IBLOCK_ID = B.ID AND FP21.CODE='HTL_LINK' LEFT JOIN b_iblock_property FP22 ON FP22.IBLOCK_ID = B.ID AND FP22.CODE='HTL_CODE' LEFT JOIN b_iblock_property FP23 ON FP23.IBLOCK_ID = B.ID AND FP23.CODE='HN_LINK' LEFT JOIN b_iblock_property FP24 ON FP24.IBLOCK_ID = B.ID AND FP24.CODE='HN_IMG' LEFT JOIN b_iblock_property FP25 ON FP25.IBLOCK_ID = B.ID AND FP25.CODE='HN_IMG_TAB' LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV4 ON FPV4.IBLOCK_PROPERTY_ID = FP4.ID AND FPV4.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV5 ON FPV5.IBLOCK_PROPERTY_ID = FP5.ID AND FPV5.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV6 ON FPV6.IBLOCK_PROPERTY_ID = FP6.ID AND FPV6.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV7 ON FPV7.IBLOCK_PROPERTY_ID = FP7.ID AND FPV7.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV8 ON FPV8.IBLOCK_PROPERTY_ID = FP8.ID AND FPV8.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV9 ON FPV9.IBLOCK_PROPERTY_ID = FP9.ID AND FPV9.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV10 ON FPV10.IBLOCK_PROPERTY_ID = FP10.ID AND FPV10.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV11 ON FPV11.IBLOCK_PROPERTY_ID = FP11.ID AND FPV11.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV12 ON FPV12.IBLOCK_PROPERTY_ID = FP12.ID AND FPV12.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV13 ON FPV13.IBLOCK_PROPERTY_ID = FP13.ID AND FPV13.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV14 ON FPV14.IBLOCK_PROPERTY_ID = FP14.ID AND FPV14.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV15 ON FPV15.IBLOCK_PROPERTY_ID = FP15.ID AND FPV15.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV16 ON FPV16.IBLOCK_PROPERTY_ID = FP16.ID AND FPV16.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV17 ON FPV17.IBLOCK_PROPERTY_ID = FP17.ID AND FPV17.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV18 ON FPV18.IBLOCK_PROPERTY_ID = FP18.ID AND FPV18.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV19 ON FPV19.IBLOCK_PROPERTY_ID = FP19.ID AND FPV19.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV20 ON FPV20.IBLOCK_PROPERTY_ID = FP20.ID AND FPV20.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV21 ON FPV21.IBLOCK_PROPERTY_ID = FP21.ID AND FPV21.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV22 ON FPV22.IBLOCK_PROPERTY_ID = FP22.ID AND FPV22.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV23 ON FPV23.IBLOCK_PROPERTY_ID = FP23.ID AND FPV23.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV24 ON FPV24.IBLOCK_PROPERTY_ID = FP24.ID AND FPV24.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV25 ON FPV25.IBLOCK_PROPERTY_ID = FP25.ID AND FPV25.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV2.IBLOCK_PROPERTY_ID AND FPV2.VALUE_ENUM = FPEN0.ID LEFT JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = FPV5.IBLOCK_PROPERTY_ID AND FPV5.VALUE_ENUM = FPEN1.ID WHERE 1=1 AND ( ((((BE.IBLOCK_ID = '33')))) AND ((((BE.ACTIVE='Y')))) AND ( ( (((NOT(FPV22.VALUE IS NULL OR length(FPV22.VALUE)<=0)))) ) ) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) GROUP BY BE.NAME,BE.ID,BE.ACTIVE, FPV1.VALUE, FPEN0.VALUE, FPEN0.ID, FPV3.VALUE, FPV0.VALUE, FPV0.VALUE_NUM, FPV4.VALUE, FPEN1.VALUE, FPEN1.ID, FPV6.VALUE, FPV7.VALUE, FPV8.VALUE, FPV9.VALUE, FPV10.VALUE, FPV11.VALUE, FPV12.VALUE, FPV13.VALUE, FPV14.VALUE, FPV15.VALUE, FPV16.VALUE, FPV17.VALUE, FPV18.VALUE, FPV19.VALUE, FPV20.VALUE, FPV21.VALUE, FPV22.VALUE, FPV23.VALUE, FPV24.VALUE, FPV25.VALUE, FPV0.VALUE, FPV0.VALUE_NUM ORDER BY FPV0.VALUE_NUM asc [[1] Can't create/write to file '/tmp/#sql_2bce_0.MAD' (Errcode: 28)]

DB query error.
Please try later.