query aptitus

SELECT a.nombre, count(aw.id_area) as n, concat('|',replace(u.search_name,' ', '-'),'|','/areas/', '|', a.slug) as routeparam FROM area a JOIN anuncio_web aw ON a.id=aw.id_area  JOIN ubigeo u ON u.id=aw.id_ubigeo WHERE a.id IN (1,2,4,3,5,12,8,10,11,13,14,19,16,9,17,18,21,23,24,25)
AND aw.online=1 AND aw.cerrado = 0 AND aw.proceso_activo = 1 AND u.id  = 3932  GROUP BY aw.id_area ORDER BY a.nombre;