7,714
社区成员
发帖
与我相关
我的任务
分享
select poster as 用户名,
sum(iif(layer = 0,1,0)) as 发贴次数,sum(iif(layer = 0,len(message),0)) as 发贴字数
sum(iif(layer = 1,1,0)) as 回贴次数,sum(iif(layer = 1,len(message),0)) as 回贴字数
From dnt_posts1 where fid = 7
and postdatetime >= #02/01/2010#
group by poster