SELECT
property_properties.property_id
FROM
property_properties
JOIN
property_attributes as property_attributes_join1
ON
property_properties.property_id = property_attributes_join1.property_id AND
property_attributes_join1.attribute_group_id = 14 AND
property_attributes_join1.attribute_value_id IN (58 )
JOIN
property_towns
ON
property_properties.town_id = property_towns.town_id
JOIN
property_areas
ON
property_towns.area_id = property_areas.area_id
JOIN
property_regions
ON
property_areas.region_id = property_regions.region_id
JOIN
property_countries
ON
property_regions.country_id = property_countries.country_id AND
property_countries.country_id IN ( 1 )
ORDER BY
property_properties.price ASC