2025-07-11 18:41:51 执行时长：6.58秒 sql:SELECT DISTINCT 证书变更.ID as [~ID~] ,[组织名称_组织信息].CorpName AS [组织名称],证书变更.[ApplyOn] AS [变更时间],(case 证书变更.[CertiPause] when 1 then '√' else '' end) AS [证书暂停],证书变更.[PauseBeginDate] AS [暂停开始日],证书变更.[PauseEndDate] AS [暂停结束日],(case 证书变更.[CertiCancel] when 1 then '√' else '' end) AS [证书撤销],(case 证书变更.[CertiRevoke] when 1 then '√' else '' end) AS [证书注销],(case 证书变更.[CertiRestore] when 1 then '√' else '' end) AS [证书恢复],(case 证书变更.[CertiInvalid] when 1 then '√' else '' end) AS [证书失效],证书变更.[CertiNo] AS [证书编号],(case 证书变更.[OrgNameChange] when 1 then '√' else '' end) AS [组织更名],证书变更.[OrgName] AS [新组织名称],(case 证书变更.[RegisterAddrChange] when 1 then '√' else '' end) AS [注册地址变更],证书变更.[RegisterAddr] AS [新注册地址],证书变更.[RegisterAddrPC] AS [注册地址邮编],(case 证书变更.[AddressChange] when 1 then '√' else '' end) AS [通讯地址变更],证书变更.[Address] AS [新通讯地址],证书变更.[AddressPC] AS [通讯地址邮编],(case 证书变更.[ProductAddrChange] when 1 then '√' else '' end) AS [生产地址变更],证书变更.[ProductAddr] AS [新生产地址],证书变更.[ProductAddrPC] AS [生产地址邮编],(case 证书变更.[StaffQtyChange] when 1 then '√' else '' end) AS [组织人数变更],证书变更.[StaffQty] AS [新组织人数],(case 证书变更.[CertiStaffQtyChange] when 1 then '√' else '' end) AS [体系人数变更],证书变更.[CertiStaffQty] AS [新体系人数],(case 证书变更.[OtherInfoChange] when 1 then '√' else '' end) AS [组织其他信息变更],[暂停原因_暂停原因].ReasonName AS [暂停原因],[撤销原因_撤销原因].ReasonName AS [撤销原因],[注销原因_注销原因].ReasonName AS [注销原因],(case 证书变更.[ReviewedAgain] when 1 then '√' else '' end) AS [已复评],证书变更.[ChangeRemarks] AS [变更备注],(case 证书变更.[ReportWithSuper] when 1 then '√' else '' end) AS [结合监督上报],(case 证书变更.[ExchangeCerti] when 1 then '√' else '' end) AS [是否换证],[项目编号_认证项目].ProjectNo AS [项目编号],[合同来源_合同来源].OrgName AS [合同来源] FROM GB_CertiChange 证书变更 WITH(NOLOCK)  LEFT JOIN GB_Corp [组织名称_组织信息] WITH(NOLOCK) ON 证书变更.CorpID = [组织名称_组织信息].CorpID LEFT JOIN Pub_PauseReason [暂停原因_暂停原因] WITH(NOLOCK) ON 证书变更.PauseReason = [暂停原因_暂停原因].ReasonCode LEFT JOIN Pub_CancelReason [撤销原因_撤销原因] WITH(NOLOCK) ON 证书变更.CancelReason = [撤销原因_撤销原因].ReasonCode LEFT JOIN Pub_RevokeReason [注销原因_注销原因] WITH(NOLOCK) ON 证书变更.RevokeReason = [注销原因_注销原因].ReasonCode LEFT JOIN GB_CertificationProject [项目编号_认证项目] WITH(NOLOCK) ON 证书变更.ProjectNo = [项目编号_认证项目].ProjectNo LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 证书变更.Org = [合同来源_合同来源].Org LEFT JOIN GB_ProjectPlan [计划编号_审核计划] WITH(NOLOCK) ON 证书变更.PlanNo = [计划编号_审核计划].PlanNo LEFT JOIN GB_ProjectPlanCerti [证书信息ID_证书信息] WITH(NOLOCK) ON 证书变更.CertiID = [证书信息ID_证书信息].ID LEFT JOIN Base_User [申请人_用户] WITH(NOLOCK) ON 证书变更.ApplyBy = [申请人_用户].UserID LEFT JOIN Pub_ApproveClass [审核类别_审核类别] WITH(NOLOCK) ON 证书变更.ApproveClass = [审核类别_审核类别].ClassCode LEFT JOIN Pub_CertificateStatus [证书状态_证书状态] WITH(NOLOCK) ON 证书变更.CertifacateStatus = [证书状态_证书状态].StatusCode WHERE [证书变更].ApplyOn>='2025-07-02' and [证书变更].ApplyOn<='2025-07-11' order by [证书变更].[ApplyOn] DESC