28,391
社区成员
发帖
与我相关
我的任务
分享
select id,title,keywords,hits,intro,adddate,author,(select count(id) from 表2 where 表2.infoid=表1.id) as commenttotal from 表1 where 表1.deltf=0 and 表1.verific=1 order by (select count(id) from 表2 where 表2.infoid=表1.id)desc