你好，可以参考下以下sql语句

select b.id,b.title,DiggNum,InfoID from KS_DiggList a inner join ks_article b on a.infoid=b.id where channelid=1 order by diggnum desc