Афиша

MySQL Query Error: SELECT BE.ID as ID,BE.NAME as NAME,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.DETAIL_PICTURE as DETAIL_PICTURE,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%m/%d/%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%m/%d/%Y')) as DATE_ACTIVE_FROM, FPEN0.VALUE as PROPERTY_ADV_RIGHTS_VALUE, FPEN0.ID as PROPERTY_ADV_RIGHTS_ENUM_ID, FPV0.ID as PROPERTY_ADV_RIGHTS_VALUE_ID, FPEN1.VALUE as PROPERTY_ADVERT_VALUE, FPEN1.ID as PROPERTY_ADVERT_ENUM_ID, FPV1.ID as PROPERTY_ADVERT_VALUE_ID, FPEN2.VALUE as PROPERTY_IMPORTANT_VALUE, FPEN2.ID as PROPERTY_IMPORTANT_ENUM_ID, FPV2.ID as PROPERTY_IMPORTANT_VALUE_ID, FPEN3.VALUE as PROPERTY_IS_VIDEOS_VALUE, FPEN3.ID as PROPERTY_IS_VIDEOS_ENUM_ID, FPV3.ID as PROPERTY_IS_VIDEOS_VALUE_ID, FPEN4.VALUE as PROPERTY_IS_PHOTOS_VALUE, FPEN4.ID as PROPERTY_IS_PHOTOS_ENUM_ID, FPV4.ID as PROPERTY_IS_PHOTOS_VALUE_ID, FPEN5.VALUE as PROPERTY_IS_FB_VALUE, FPEN5.ID as PROPERTY_IS_FB_ENUM_ID, FPV5.ID as PROPERTY_IS_FB_VALUE_ID, FPEN6.VALUE as PROPERTY_IS_IN_VALUE, FPEN6.ID as PROPERTY_IS_IN_ENUM_ID, FPV6.ID as PROPERTY_IS_IN_VALUE_ID, FPEN7.VALUE as PROPERTY_IS_TW_VALUE, FPEN7.ID as PROPERTY_IS_TW_ENUM_ID, FPV7.ID as PROPERTY_IS_TW_VALUE_ID, FPEN8.VALUE as PROPERTY_IS_EX_VALUE, FPEN8.ID as PROPERTY_IS_EX_ENUM_ID, FPV8.ID as PROPERTY_IS_EX_VALUE_ID,L.DIR as LANG_DIR,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%m/%d/%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%m/%d/%Y')) as ACTIVE_FROM,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,BE.IBLOCK_ID as IBLOCK_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID 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='ADV_RIGHTS' LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='ADVERT' LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='IMPORTANT' LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='IS_VIDEOS' LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.CODE='IS_PHOTOS' LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.CODE='IS_FB' LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND FP6.CODE='IS_IN' LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND FP7.CODE='IS_TW' LEFT JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND FP8.CODE='IS_EX' LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND FP9.CODE='HIDE' LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND FP10.CODE='MAGAZINE' 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_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV0.IBLOCK_PROPERTY_ID AND FPV0.VALUE_ENUM = FPEN0.ID LEFT JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = FPV1.IBLOCK_PROPERTY_ID AND FPV1.VALUE_ENUM = FPEN1.ID LEFT JOIN b_iblock_property_enum FPEN2 ON FPEN2.PROPERTY_ID = FPV2.IBLOCK_PROPERTY_ID AND FPV2.VALUE_ENUM = FPEN2.ID LEFT JOIN b_iblock_property_enum FPEN3 ON FPEN3.PROPERTY_ID = FPV3.IBLOCK_PROPERTY_ID AND FPV3.VALUE_ENUM = FPEN3.ID LEFT JOIN b_iblock_property_enum FPEN4 ON FPEN4.PROPERTY_ID = FPV4.IBLOCK_PROPERTY_ID AND FPV4.VALUE_ENUM = FPEN4.ID LEFT JOIN b_iblock_property_enum FPEN5 ON FPEN5.PROPERTY_ID = FPV5.IBLOCK_PROPERTY_ID AND FPV5.VALUE_ENUM = FPEN5.ID LEFT JOIN b_iblock_property_enum FPEN6 ON FPEN6.PROPERTY_ID = FPV6.IBLOCK_PROPERTY_ID AND FPV6.VALUE_ENUM = FPEN6.ID LEFT JOIN b_iblock_property_enum FPEN7 ON FPEN7.PROPERTY_ID = FPV7.IBLOCK_PROPERTY_ID AND FPV7.VALUE_ENUM = FPEN7.ID LEFT JOIN b_iblock_property_enum FPEN8 ON FPEN8.PROPERTY_ID = FPV8.IBLOCK_PROPERTY_ID AND FPV8.VALUE_ENUM = FPEN8.ID LEFT JOIN b_iblock_property_enum FPEN9 ON FPEN9.PROPERTY_ID = FPV9.IBLOCK_PROPERTY_ID AND FPV9.VALUE_ENUM = FPEN9.ID WHERE 1=1 AND ( ((((B.IBLOCK_TYPE_ID LIKE 'content')))) AND ((((BE.IBLOCK_ID = '1')))) 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 ((( FPEN9.VALUE IS NULL OR NOT (FPEN9.VALUE LIKE 'Y')))) AND (((FPV10.VALUE_NUM IS NULL))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY BE.ACTIVE_FROM desc LIMIT 25[Disk full (/www/natali/upload/_mysql_tmp/#sql_789_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]

DB query error.
Please try later.