select top 10 a.id,a.title,num from KS_U_song a,(select InfoID, count(InfoID) as num from KS_Comment where channelid=113 group by InfoID) b where a.id=b.InfoID order by b.num desc