34,593
社区成员
发帖
与我相关
我的任务
分享
select
a.magtitle,a.pid,b.pclick,(SELECT COUNT(*) AS Expr1 FROM dbo.social_circle_post WHERE social_circle_post.circleid>0 and social_circle_post.stype=2) AS num2
from
social_circle_post as a
inner join
social_circle_post_dynamic as b
on
a.pid=b.subjectid
where
stype=1 and a.circleid>0
group by
a.magtitle,a.pid,b.pclick--这里 跟的是没有聚合的部分