论坛上有调用最多评论的sql

请教如何调用最新评论

我菜鸟 谢谢

下面的是调用最多评论的

select top 12 a.id,title,adddate,num from ks_article a,(select infoid,count(*) as num from ks_comment where channelid=1 group by infoid)b where a.id=b.infoid order by b.num desc

[loop=12]
<li><a href="{$Field(id,GetInfoUrl,1,1)}">{$Field(title,Text,0,...,0,)}</a>({$Field(num,Num,0,2)})</li>
[/loop]