select _b.title as classtitle,_b.newsurl,_a.title,_a.id
,(select count(unid) from dbo.news_re b where articleid=_a.id ) as pinglun
,_a.counts,_a.province as pro,_a.city,_a.filepath,_a.filename
, (select count(pfid) from dbo.news_pf b where id=_a.id) as pingfen
,_a.addtime
from news _a join classlist _b on _a.class=_b.id
where _a.class=13
,(select count(unid) from dbo.news_re b where articleid=_a.id ) as pinglun
,_a.counts,_a.province as pro,_a.city,_a.filepath,_a.filename
, (select count(pfid) from dbo.news_pf b where id=_a.id) as pingfen
,_a.addtime
from news _a join classlist _b on _a.class=_b.id
where _a.class=13
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货