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