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

原理就差不多上面那样了．循环体自己写吧