2026-03-09 14:17:07 执行时长：5.53秒 sql:select count(*) from ( SELECT DISTINCT 人员审核活动统计.ID as [~ID~]  FROM GB_AuditorAuditHis 人员审核活动统计 WITH(NOLOCK)  LEFT JOIN GB_Auditor [人员编号_人员信息表] WITH(NOLOCK) ON 人员审核活动统计.AuditorCode = [人员编号_人员信息表].AuditorCode LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 人员审核活动统计.Corp = [组织名称_组织信息].CorpID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 人员审核活动统计.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertiField [认证领域_认证领域] WITH(NOLOCK) ON 人员审核活动统计.FieldCode = [认证领域_认证领域].FieldCode LEFT JOIN Pub_CertiType [标准代码_认证标准] WITH(NOLOCK) ON 人员审核活动统计.StandardCode = [标准代码_认证标准].ID LEFT JOIN Pub_ApproveMode [审核方式_审核方式] WITH(NOLOCK) ON 人员审核活动统计.ApproveMode = [审核方式_审核方式].ApproveModeCode LEFT JOIN Pub_Code [组内职责_代码表] WITH(NOLOCK) ON 人员审核活动统计.Duty = [组内职责_代码表].CodeID LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 人员审核活动统计.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Pub_QCType [注册级别_人员资质类型] WITH(NOLOCK) ON 人员审核活动统计.TechLevel = [注册级别_人员资质类型].QCCode LEFT JOIN Pub_Witness [见证情况_见证情况] WITH(NOLOCK) ON 人员审核活动统计.WitnessSituation = [见证情况_见证情况].WitnessCode LEFT JOIN Base_Org [人员合同来源_组织机构] WITH(NOLOCK) ON 人员审核活动统计.AuditorOrg = [人员合同来源_组织机构].OrgID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 人员审核活动统计.Org = [合同来源_合同来源].Org LEFT JOIN Pub_DecideResult [批准结论_批准结论] WITH(NOLOCK) ON 人员审核活动统计.DecideResult = [批准结论_批准结论].ResultCode WHERE [人员审核活动统计].BeginDate>='2025-12-09' ) as CurrentCount