SELECT 
	BE.ID as ID,
	B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,
	BE.PREVIEW_PICTURE as PREVIEW_PICTURE,

	##################################################

	FPS0.PROPERTY_206 as 			PROPERTY_PREVIEW_TEXT_RU_VALUE,
	FPS0.DESCRIPTION_206 as 		PROPERTY_PREVIEW_TEXT_RU_DESCRIPTION,
	concat(BE.ID , ':' , 206) as 	PROPERTY_PREVIEW_TEXT_RU_VALUE_ID,

	##################################################

	FPEN0.VALUE as PROPERTY_ADVERTISED_VALUE,
	FPEN0.ID as PROPERTY_ADVERTISED_ENUM_ID,
	concat(BE.ID , ':' , 37) as PROPERTY_ADVERTISED_VALUE_ID,
	
	##################################################

	FPS0.PROPERTY_194 as PROPERTY_PRICE_VALUE,
	FPS0.DESCRIPTION_194 as PROPERTY_PRICE_DESCRIPTION,
	concat(BE.ID , ':' , 194) as PROPERTY_PRICE_VALUE_ID,
	
	##################################################

	FPS0.PROPERTY_422 as PROPERTY_PRICE_RENT_VALUE,
	FPS0.DESCRIPTION_422 as PROPERTY_PRICE_RENT_DESCRIPTION,
	concat(BE.ID , ':' , 422) as PROPERTY_PRICE_RENT_VALUE_ID,
	
	##################################################

	FPS0.PROPERTY_217 as PROPERTY_COMPANY_VALUE,
	FPS0.DESCRIPTION_217 as PROPERTY_COMPANY_DESCRIPTION,
	concat(BE.ID , ':' , 217) as PROPERTY_COMPANY_VALUE_ID,
	
	##################################################

	FPEN1.VALUE as PROPERTY_PRICE_ON_REQUEST_VALUE,
	FPEN1.ID as PROPERTY_PRICE_ON_REQUEST_ENUM_ID,
	concat(BE.ID , ':' , 36) as PROPERTY_PRICE_ON_REQUEST_VALUE_ID,
	
	##################################################
	
	FPEN2.VALUE as PROPERTY_CURRENCY_VALUE,
	FPEN2.ID as PROPERTY_CURRENCY_ENUM_ID,
	concat(BE.ID , ':' , 34) as PROPERTY_CURRENCY_VALUE_ID,
	

FPEN3.VALUE as PROPERTY_CURRENCY_RENT_VALUE,
	FPEN3.ID as PROPERTY_CURRENCY_RENT_ENUM_ID,
	concat(BE.ID , ':' , 423) as PROPERTY_CURRENCY_RENT_VALUE_ID,
	

FPS0.PROPERTY_201 as PROPERTY_NAME_RU_VALUE,
	FPS0.DESCRIPTION_201 as PROPERTY_NAME_RU_DESCRIPTION,
	concat(BE.ID , ':' , 201) as PROPERTY_NAME_RU_VALUE_ID,
	

JFPS0.PROPERTY_131 as PROPERTY_COUNTRY_PROPERTY_NAME_RU_VALUE,
	JFPS0.DESCRIPTION_131 as PROPERTY_COUNTRY_PROPERTY_NAME_RU_DESCRIPTION,
	concat(BE0.ID , ':' , 131) as PROPERTY_NAME_RU_COUNTRY_VALUE_ID,
	

JFPS1.PROPERTY_135 as PROPERTY_REGION_PROPERTY_NAME_RU_VALUE,
	JFPS1.DESCRIPTION_135 as PROPERTY_REGION_PROPERTY_NAME_RU_DESCRIPTION,
	concat(BE1.ID , ':' , 135) as PROPERTY_NAME_RU_REGION_VALUE_ID,
	

JFPS2.PROPERTY_129 as PROPERTY_CITY_PROPERTY_NAME_RU_VALUE,
	JFPS2.DESCRIPTION_129 as PROPERTY_CITY_PROPERTY_NAME_RU_DESCRIPTION,
	concat(BE2.ID , ':' , 129) as PROPERTY_NAME_RU_CITY_VALUE_ID,
	

	L.DIR as LANG_DIR,BE.SORT as SORT,
	DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,
	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
INNER JOIN b_iblock_element_prop_s20 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = 37 AND FPS0.PROPERTY_37 = FPEN0.ID
LEFT JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = 36 AND FPS0.PROPERTY_36 = FPEN1.ID
LEFT JOIN b_iblock_property_enum FPEN2 ON FPEN2.PROPERTY_ID = 34 AND FPS0.PROPERTY_34 = FPEN2.ID
LEFT JOIN b_iblock_property_enum FPEN3 ON FPEN3.PROPERTY_ID = 423 AND FPS0.PROPERTY_423 = FPEN3.ID
LEFT JOIN b_iblock_element BE0 ON BE0.ID = FPS0.PROPERTY_214 AND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))
LEFT JOIN b_iblock_element BE1 ON BE1.ID = FPS0.PROPERTY_215 AND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))
LEFT JOIN b_iblock_element BE2 ON BE2.ID = FPS0.PROPERTY_216 AND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))
LEFT JOIN b_iblock_element_prop_s4 JFPS0 ON JFPS0.IBLOCK_ELEMENT_ID = BE0.ID
LEFT JOIN b_iblock_element_prop_s5 JFPS1 ON JFPS1.IBLOCK_ELEMENT_ID = BE1.ID
LEFT JOIN b_iblock_element_prop_s6 JFPS2 ON JFPS2.IBLOCK_ELEMENT_ID = BE2.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 ('sale'))) 
) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID

WHERE
1=1 AND ( 
		((((BE.IBLOCK_ID = '20')))) 
		AND ((((BE.ACTIVE='Y')))) 
		AND ( 
				( 
					((((FPS0.PROPERTY_194 >= '0')))) 
					AND ((((FPEN2.VALUE LIKE '€')))) 
				) 
			OR ( 
				((((FPS0.PROPERTY_194 >= '0')))) 
				AND ((((FPEN2.VALUE LIKE '$')))) 
				) 
			OR ( 
				((((FPS0.PROPERTY_194 >= '0'))))
				AND ((((FPEN2.VALUE LIKE '₷'))))
				)
			OR ( 
				(((FPS0.PROPERTY_194 IS NULL))) 
				) 
			) 
		) 
		AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY
BE.SORT desc ,BE.DATE_CREATE desc
LIMIT 0, 24;