LINE: 802
MySQL Query Error: SELECT BE.NAME as NAME,BE.ID as ID,BE.CODE as CODE, FPEN0.VALUE as PROPERTY_LOCALITY_AREA_VALUE, FPEN0.ID as PROPERTY_LOCALITY_AREA_ENUM_ID, concat(BE.ID , ':' , 673) as PROPERTY_LOCALITY_AREA_VALUE_ID, FPS0.PROPERTY_675 as PROPERTY_STREET_VALUE, concat(BE.ID , ':' , 675) as PROPERTY_STREET_VALUE_ID, FPS0.PROPERTY_676 as PROPERTY_HOUSE_VALUE, concat(BE.ID , ':' , 676) as PROPERTY_HOUSE_VALUE_ID, FPS0.PROPERTY_678 as PROPERTY_FULL_AREA_VALUE, concat(BE.ID , ':' , 678) as PROPERTY_FULL_AREA_VALUE_ID, FPS0.PROPERTY_680 as PROPERTY_KITCHEN_AREA_VALUE, concat(BE.ID , ':' , 680) as PROPERTY_KITCHEN_AREA_VALUE_ID, FPS0.PROPERTY_679 as PROPERTY_LIVING_AREA_VALUE, concat(BE.ID , ':' , 679) as PROPERTY_LIVING_AREA_VALUE_ID, FPS0.PROPERTY_681 as PROPERTY_PRICE_VALUE, concat(BE.ID , ':' , 681) as PROPERTY_PRICE_VALUE_ID, FPS0.PROPERTY_677 as PROPERTY_APARTMENT_VALUE, concat(BE.ID , ':' , 677) as PROPERTY_APARTMENT_VALUE_ID, FPS0.PROPERTY_691 as PROPERTY_FLOOR_VALUE, concat(BE.ID , ':' , 691) as PROPERTY_FLOOR_VALUE_ID, FPS0.PROPERTY_692 as PROPERTY_NUMBER_FLOORS_LIVING_VALUE, concat(BE.ID , ':' , 692) as PROPERTY_NUMBER_FLOORS_LIVING_VALUE_ID, FPS0.PROPERTY_823 as PROPERTY_IMAGES_VALUE, FPS0.PROPERTY_829 as PROPERTY_IMAGES_PLAN_VALUE, FPS0.PROPERTY_824 as PROPERTY_STUDIO_VALUE, concat(BE.ID , ':' , 824) as PROPERTY_STUDIO_VALUE_ID, FPS0.PROPERTY_697 as PROPERTY_BUILT_YEAR_VALUE, concat(BE.ID , ':' , 697) as PROPERTY_BUILT_YEAR_VALUE_ID, FPS0.PROPERTY_699 as PROPERTY_READY_QUARTER_VALUE, concat(BE.ID , ':' , 699) as PROPERTY_READY_QUARTER_VALUE_ID, FPEN1.VALUE as PROPERTY_HOUSE_MATERIAL_VALUE, FPEN1.ID as PROPERTY_HOUSE_MATERIAL_ENUM_ID, concat(BE.ID , ':' , 689) as PROPERTY_HOUSE_MATERIAL_VALUE_ID, FPS0.PROPERTY_702 as PROPERTY_COORDINATES_VALUE, concat(BE.ID , ':' , 702) as PROPERTY_COORDINATES_VALUE_ID, FPEN2.VALUE as PROPERTY_CLASS_VALUE, FPEN2.ID as PROPERTY_CLASS_ENUM_ID, concat(BE.ID , ':' , 813) as PROPERTY_CLASS_VALUE_ID, FPEN3.VALUE as PROPERTY_BALCONY_EXIST_VALUE, FPEN3.ID as PROPERTY_BALCONY_EXIST_ENUM_ID, concat(BE.ID , ':' , 693) as PROPERTY_BALCONY_EXIST_VALUE_ID, FPS0.PROPERTY_682 as PROPERTY_COUNT_ROOMS_VALUE, concat(BE.ID , ':' , 682) as PROPERTY_COUNT_ROOMS_VALUE_ID 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_s37 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = 673 AND FPS0.PROPERTY_673 = FPEN0.ID LEFT JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = 689 AND FPS0.PROPERTY_689 = FPEN1.ID LEFT JOIN b_iblock_property_enum FPEN2 ON FPEN2.PROPERTY_ID = 813 AND FPS0.PROPERTY_813 = FPEN2.ID LEFT JOIN b_iblock_property_enum FPEN3 ON FPEN3.PROPERTY_ID = 693 AND FPS0.PROPERTY_693 = FPEN3.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.CODE IN ('novye-matryeshki'))) ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID WHERE 1=1 AND ( ((((BE.ACTIVE='Y')))) AND ((((BE.IBLOCK_ID = '37')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY FPS0.PROPERTY_681 asc [[3] Error writing file '/tmp/MYrtCL1G' (Errcode: 28 - No space left on device)]
|