script de raul

DECLARE @UBI VARCHAR(3)=15

 SELECT arb.ID_CATEGORIA,arb.NOM_CATEGORIA Nombre,COUNT(avi.ID_AVISO) n,
 'http://kotear.pe/busqueda/?q&categs='+CONVERT(VARCHAR(6),arb.ID_CATEGORIA)+'&ub='+@UBI+'&ubic[]='+@UBI url
FROM KO_CATEGORIA_ARBOL arb
INNER JOIN KO_AVISO_CATEGORIA acat ON acat.ID_CATEGORIA=arb.ID_CATEGORIA
AND arb.ADULTO=0
INNER JOIN KO_AVISO avi ON avi.ID_AVISO=acat.ID_AVISO AND avi.EST=1
AND avi.FLAG_MODERACION=0 AND FLAG_MODERACION_ADMIN=0
AND FEC_FIN>GETDATE()
AND avi.ID_UBIGEO = 15
AND arb.ID_CATEGORIA IN (231,221,237,
 243,235,208,228,
 234,226,233,232,
 244,230,1909,
 229,1621,219,247,1381,
 241,217,3489
 )
GROUP BY arb.ID_CATEGORIA,arb.NOM_CATEGORIA;