Utilice el mapa para buscar la agencia certificada de su elección

Todas las categorías

SELECT property_type, COUNT(id) AS num_art FROM content INNER JOIN custom_field_value_properties ON custom_field_value_properties.id_content = content.id INNER JOIN content_owner ON content_owner.id_content = content.id WHERE property_description != '' AND property_price >= 500000 AND service = 'website' AND lng = 'it' AND content.status = 1 AND usr = 'Youralisa' GROUP BY property_type ORDER BY num_art DESC