consulta buena para kotear

SELECT  agr.L1_NOM AS nombre, COUNT(agr.L1) AS n, CONVERT(VARCHAR(6),agr.L1) + '&ub='+CONVERT(VARCHAR(6),avi.ID_UBIGEO) +'&ubic[]='+CONVERT(VARCHAR(6),avi.ID_UBIGEO) AS routeparam FROM KO_AVISO_CATEGORIA acat INNER JOIN KO_AVISO avi ON avi.ID_AVISO=acat.ID_AVISO AND avi.EST=1 INNER JOIN KO_AGRUPADOR agr ON agr.L1 IN (231,221,237,243,235,208,228,234,226,233,232,244,230,1909, 229,1621,219,247,1381,241,217,3489) AND (acat.ID_CATEGORIA=agr.ID_CATEGORIA) AND avi.FLAG_MODERACION=0 AND FLAG_MODERACION_ADMIN=0 AND FEC_FIN>GETDATE() AND avi.ID_UBIGEO = 15 GROUP BY agr.L1_NOM,agr.L1 , avi.ID_UBIGEO