complex 382 not foundSELECT 	complex.complex_id,
                complex.name,
                'EUR' AS base_currency,
				complex.name AS complex,
				complex.lat,
				complex.lng,
				complex.active,
				complex.year,
				complex.no_floors,
                complex.no_buildings,
				complex.city,
				complex.beach,
				complex.shopping,
				complex.directory,
                complex.video_url,
				property.let_self,
				complex.area_id,
				txt_lang.title AS area,
				txt.resort_id,
				txt_lang.content AS information,
				MIN(property.price_min) AS price_min,
				MAX(property.price_max) AS price_max,
				GREATEST(property.price_min,property.price_max) AS end_price2,
				MAX(property.price_min) AS end_price3,
				COUNT(property.property_id) AS no_properties,

                MIN(property.floor_size_min) AS floor_size_min, MAX(property.floor_size_max) AS floor_size_max,
                MIN(property.plot_size_min) AS plot_size_min, MAX(property.plot_size_max) AS plot_size_max,
                MIN(property.garden_size_min) AS garden_size_min, MAX(property.garden_size_max) AS garden_size_max,
                MIN(property.bedrooms_min) AS bedrooms_min, MAX(property.bedrooms_max) AS bedrooms_max,
                MIN(property.livingrooms_min) AS livingrooms_min, MAX(property.livingrooms_max) AS livingrooms_max,
                MIN(property.bathrooms_min) AS bathrooms_min, MAX(property.bathrooms_max) AS bathrooms_max,
                MIN(property.toilets_min) AS toilets_min, MAX(property.toilets_max) AS toilets_max,
                MIN(property.balconies_min) AS balconies_min, MAX(property.balconies_max) AS balconies_max,
                MIN(property.terraces_min) AS terraces_min, MAX(property.terraces_max) AS terraces_max,

				MAX(property.property_id) AS property_id,
                MAX(property.updated_at) AS updated_at,
                complex.number_of_pictures AS number_of_complex_pictures,
                complex.video_url AS complex_video,
                complex.management_fee


                FROM property,txt_lang,txt,complex

                WHERE 
				
				complex.complex_id='382' AND 
				txt_lang.txt_id=txt.txt_id AND 
				complex.area_id=txt_lang.txt_id AND 
				txt_lang.lang_id='41' AND 
				property.complex_id=complex.complex_id AND 
				complex.directory!='' AND 
				txt.txt_id=complex.area_id AND 
				(property.price_min>0) AND
				complex.active='1' 
				GROUP BY complex.complex_id ORDER BY price_min;