2025-08-29 16:33:30 执行时长：5.16秒 sql:select count(*) from ( SELECT DISTINCT 组织信息.ID as [~ID~] ,组织信息.[CorpName] AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],[所在地区_所在地区].AreaName AS [所在地区],组织信息.[RegisterAddress] AS [注册地址],组织信息.[StaffQty] AS [组织人数],组织信息.[SocialSecurity] AS [社保人数],组织信息.[Tradecode] AS [经济行业代码],组织信息.[UpdateOn] AS [修改时间] FROM GB_Corp 组织信息 WITH(NOLOCK)  LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 组织信息.City = [城市_城市表].CityCode LEFT JOIN Pub_Province [生产地址所在省份_省份] WITH(NOLOCK) ON 组织信息.ProductProvince = [生产地址所在省份_省份].ProvinceCode LEFT JOIN Pub_City [生产地址所在城市_城市表] WITH(NOLOCK) ON 组织信息.ProductCity = [生产地址所在城市_城市表].CityCode LEFT JOIN Pub_Area [生产地址所在地区_所在地区] WITH(NOLOCK) ON 组织信息.ProductArea = [生产地址所在地区_所在地区].AreaCode LEFT JOIN Pub_CurrencyType [注册资本币种_币种] WITH(NOLOCK) ON 组织信息.CapitalCurrType = [注册资本币种_币种].CurrencyCode LEFT JOIN Pub_Code [开票类型_代码表] WITH(NOLOCK) ON 组织信息.InvoiceType = [开票类型_代码表].CodeID LEFT JOIN Pub_Code [组织运作状况_代码表] WITH(NOLOCK) ON 组织信息.CorpStatus = [组织运作状况_代码表].CodeID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 组织信息.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 组织信息.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 组织信息.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_CorpType [企业性质_企业类型] WITH(NOLOCK) ON 组织信息.CorpType = [企业性质_企业类型].Code WHERE (((exists (select a.id from gb_projectplan a inner join gb_Projectplanteam b on a.taskno=b.taskno and b.auditorcode='ISC[S]0262' and a.corp=[组织信息].[corpid])))) AND (组织信息.Org = '2102') ) as CurrentCount

2025-08-29 16:33:35 执行时长：7.17秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 组织信息.ID as [~ID~] ,组织信息.[CorpName] AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],[所在地区_所在地区].AreaName AS [所在地区],组织信息.[RegisterAddress] AS [注册地址],组织信息.[StaffQty] AS [组织人数],组织信息.[SocialSecurity] AS [社保人数],组织信息.[Tradecode] AS [经济行业代码],组织信息.[UpdateOn] AS [修改时间] FROM GB_Corp 组织信息 WITH(NOLOCK)  LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 组织信息.City = [城市_城市表].CityCode LEFT JOIN Pub_Province [生产地址所在省份_省份] WITH(NOLOCK) ON 组织信息.ProductProvince = [生产地址所在省份_省份].ProvinceCode LEFT JOIN Pub_City [生产地址所在城市_城市表] WITH(NOLOCK) ON 组织信息.ProductCity = [生产地址所在城市_城市表].CityCode LEFT JOIN Pub_Area [生产地址所在地区_所在地区] WITH(NOLOCK) ON 组织信息.ProductArea = [生产地址所在地区_所在地区].AreaCode LEFT JOIN Pub_CurrencyType [注册资本币种_币种] WITH(NOLOCK) ON 组织信息.CapitalCurrType = [注册资本币种_币种].CurrencyCode LEFT JOIN Pub_Code [开票类型_代码表] WITH(NOLOCK) ON 组织信息.InvoiceType = [开票类型_代码表].CodeID LEFT JOIN Pub_Code [组织运作状况_代码表] WITH(NOLOCK) ON 组织信息.CorpStatus = [组织运作状况_代码表].CodeID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 组织信息.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 组织信息.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 组织信息.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_CorpType [企业性质_企业类型] WITH(NOLOCK) ON 组织信息.CorpType = [企业性质_企业类型].Code WHERE (((exists (select a.id from gb_projectplan a inner join gb_Projectplanteam b on a.taskno=b.taskno and b.auditorcode=''ISC[S]0262'' and a.corp=[组织信息].[corpid])))) AND (组织信息.Org = ''2103'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 组织信息.ID as [~ID~] ,组织信息.[UpdateOn] AS [修改时间] FROM GB_Corp 组织信息 WITH(NOLOCK)  LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 组织信息.City = [城市_城市表].CityCode LEFT JOIN Pub_Province [生产地址所在省份_省份] WITH(NOLOCK) ON 组织信息.ProductProvince = [生产地址所在省份_省份].ProvinceCode LEFT JOIN Pub_City [生产地址所在城市_城市表] WITH(NOLOCK) ON 组织信息.ProductCity = [生产地址所在城市_城市表].CityCode LEFT JOIN Pub_Area [生产地址所在地区_所在地区] WITH(NOLOCK) ON 组织信息.ProductArea = [生产地址所在地区_所在地区].AreaCode LEFT JOIN Pub_CurrencyType [注册资本币种_币种] WITH(NOLOCK) ON 组织信息.CapitalCurrType = [注册资本币种_币种].CurrencyCode LEFT JOIN Pub_Code [开票类型_代码表] WITH(NOLOCK) ON 组织信息.InvoiceType = [开票类型_代码表].CodeID LEFT JOIN Pub_Code [组织运作状况_代码表] WITH(NOLOCK) ON 组织信息.CorpStatus = [组织运作状况_代码表].CodeID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 组织信息.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 组织信息.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 组织信息.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_CorpType [企业性质_企业类型] WITH(NOLOCK) ON 组织信息.CorpType = [企业性质_企业类型].Code WHERE (((exists (select a.id from gb_projectplan a inner join gb_Projectplanteam b on a.taskno=b.taskno and b.auditorcode=''ISC[S]0262'' and a.corp=[组织信息].[corpid])))) AND (组织信息.Org = ''2103'')'

2025-08-29 16:33:38 执行时长：8.25秒 sql:EXEC dbo.P_ShowNew @QueryStr = N' SELECT DISTINCT 组织信息.ID as [~ID~] ,组织信息.[CorpName] AS [组织名称],[合同来源_合同来源].OrgName AS [合同来源],[省份_省份].Province AS [省份],[所在地区_所在地区].AreaName AS [所在地区],组织信息.[RegisterAddress] AS [注册地址],组织信息.[StaffQty] AS [组织人数],组织信息.[SocialSecurity] AS [社保人数],组织信息.[Tradecode] AS [经济行业代码],组织信息.[UpdateOn] AS [修改时间] FROM GB_Corp 组织信息 WITH(NOLOCK)  LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 组织信息.City = [城市_城市表].CityCode LEFT JOIN Pub_Province [生产地址所在省份_省份] WITH(NOLOCK) ON 组织信息.ProductProvince = [生产地址所在省份_省份].ProvinceCode LEFT JOIN Pub_City [生产地址所在城市_城市表] WITH(NOLOCK) ON 组织信息.ProductCity = [生产地址所在城市_城市表].CityCode LEFT JOIN Pub_Area [生产地址所在地区_所在地区] WITH(NOLOCK) ON 组织信息.ProductArea = [生产地址所在地区_所在地区].AreaCode LEFT JOIN Pub_CurrencyType [注册资本币种_币种] WITH(NOLOCK) ON 组织信息.CapitalCurrType = [注册资本币种_币种].CurrencyCode LEFT JOIN Pub_Code [开票类型_代码表] WITH(NOLOCK) ON 组织信息.InvoiceType = [开票类型_代码表].CodeID LEFT JOIN Pub_Code [组织运作状况_代码表] WITH(NOLOCK) ON 组织信息.CorpStatus = [组织运作状况_代码表].CodeID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 组织信息.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 组织信息.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 组织信息.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_CorpType [企业性质_企业类型] WITH(NOLOCK) ON 组织信息.CorpType = [企业性质_企业类型].Code WHERE (((exists (select a.id from gb_projectplan a inner join gb_Projectplanteam b on a.taskno=b.taskno and b.auditorcode=''ISC[S]0262'' and a.corp=[组织信息].[corpid])))) AND (组织信息.Org = ''2102'') ',@PageSize = 100, @PageCurrent = 1, @FdShow = '',@FdOrder = '[修改时间] DESC',@OnlyID = N' SELECT DISTINCT 组织信息.ID as [~ID~] ,组织信息.[UpdateOn] AS [修改时间] FROM GB_Corp 组织信息 WITH(NOLOCK)  LEFT JOIN Pub_City [城市_城市表] WITH(NOLOCK) ON 组织信息.City = [城市_城市表].CityCode LEFT JOIN Pub_Province [生产地址所在省份_省份] WITH(NOLOCK) ON 组织信息.ProductProvince = [生产地址所在省份_省份].ProvinceCode LEFT JOIN Pub_City [生产地址所在城市_城市表] WITH(NOLOCK) ON 组织信息.ProductCity = [生产地址所在城市_城市表].CityCode LEFT JOIN Pub_Area [生产地址所在地区_所在地区] WITH(NOLOCK) ON 组织信息.ProductArea = [生产地址所在地区_所在地区].AreaCode LEFT JOIN Pub_CurrencyType [注册资本币种_币种] WITH(NOLOCK) ON 组织信息.CapitalCurrType = [注册资本币种_币种].CurrencyCode LEFT JOIN Pub_Code [开票类型_代码表] WITH(NOLOCK) ON 组织信息.InvoiceType = [开票类型_代码表].CodeID LEFT JOIN Pub_Code [组织运作状况_代码表] WITH(NOLOCK) ON 组织信息.CorpStatus = [组织运作状况_代码表].CodeID LEFT JOIN Base_OrgV [合同来源_合同来源] WITH(NOLOCK) ON 组织信息.Org = [合同来源_合同来源].Org LEFT JOIN Pub_Province [省份_省份] WITH(NOLOCK) ON 组织信息.Province = [省份_省份].ProvinceCode LEFT JOIN Pub_Area [所在地区_所在地区] WITH(NOLOCK) ON 组织信息.Area = [所在地区_所在地区].AreaCode LEFT JOIN Pub_CorpType [企业性质_企业类型] WITH(NOLOCK) ON 组织信息.CorpType = [企业性质_企业类型].Code WHERE (((exists (select a.id from gb_projectplan a inner join gb_Projectplanteam b on a.taskno=b.taskno and b.auditorcode=''ISC[S]0262'' and a.corp=[组织信息].[corpid])))) AND (组织信息.Org = ''2102'')'

2025-08-29 16:49:27 执行时长：7.02秒 sql:DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20538-2025-QEO-E_24884') delete from  GB_ProjectPlanCerti where ProjectNo = N'20538-2025-QEO-E_24884' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCerti' and keyvalue in (select id from  GB_ProjectPlanCerti where ProjectNo = N'20538-2025-QEO-E_24884') delete from  GB_ProjectPlanCerti where ProjectNo = N'20538-2025-QEO-E_24884' DELETE FROM base_bizColumnattach WHERE accesspath='GB_CertiDoc' and keyvalue in (select id from  GB_CertiDoc where ProjectNo = N'20538-2025-QEO-E_24884') delete from  GB_CertiDoc where ProjectNo = N'20538-2025-QEO-E_24884' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanEnergy' and keyvalue in (select id from  GB_ProjectPlanEnergy where PlanNo = N'20538-2025-QEO-E_24884-500') delete from  GB_ProjectPlanEnergy where PlanNo = N'20538-2025-QEO-E_24884-500' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'202505130063') delete from  GB_ProjectPlanTeam where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'202505130063') delete from  GB_ProjectPlanTeam where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'202505130063') delete from  GB_AuditProblem where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'202505130063') delete from  GB_ProjectPlanTeam where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'202505130063') delete from  GB_AuditProblem where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'202505130063') delete from  GB_ProjectPlanTeam where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_InvalidDoc' and keyvalue in (select id from  GB_InvalidDoc where TaskNo = N'202505130063') delete from  GB_InvalidDoc where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'202505130063') delete from  GB_ProjectPlanTeam where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'202505130063') delete from  GB_AuditorContactRecord where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditProblem' and keyvalue in (select id from  GB_AuditProblem where TaskNo = N'202505130063') delete from  GB_AuditProblem where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'202505130063') delete from  GB_ProjectPlanTeam where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_AuditorContactRecord' and keyvalue in (select id from  GB_AuditorContactRecord where TaskNo = N'202505130063') delete from  GB_AuditorContactRecord where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanCombine' and keyvalue in (select id from  GB_ProjectPlanCombine where TaskNo = N'202505130063') delete from  GB_ProjectPlanCombine where TaskNo = N'202505130063' DELETE FROM base_bizColumnattach WHERE accesspath='GB_ProjectPlanTeam' and keyvalue in (select id from  GB_ProjectPlanTeam where TaskNo = N'202505130063') delete from  GB_ProjectPlanTeam where TaskNo = N'202505130063' DELETE FROM GB_ProjectPlan WHERE ID='505000089' DELETE FROM base_bizattach WHERE bizentityid='003002' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='003002' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='008001' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='008001' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='003003' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='003003' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='003004' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='003004' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='003005' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='003005' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='006001' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='006001' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='006002' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='006002' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='006003' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='006003' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='004003' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='004003' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='004004' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='004004' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='008002' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='008002' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='003006' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='003006' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='001035001' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='001035001' and keyvalue='505000089' DELETE FROM base_bizattach WHERE bizentityid='003025' and keyvalue='505000089' DELETE FROM base_bizColumnattach WHERE bizentityid='003025' and keyvalue='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003002' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='003002' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008001' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='008001' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003003' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='003003' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003004' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='003004' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003005' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='003005' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006001' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='006001' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006002' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='006002' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='006003' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='006003' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004003' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='004003' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='004004' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='004004' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='008002' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='008002' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003006' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='003006' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='001035001' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='001035001' and rowid='505000089' DELETE FROM wf_workflowinstancedetail where workflowinstanceid in (select id from wf_workflowinstance where bizentityid='003025' and rowid='505000089') DELETE FROM wf_workflowinstance where bizentityid='003025' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003002' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='003002' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008001' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='008001' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003003' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='003003' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003004' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='003004' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003005' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='003005' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006001' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='006001' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006002' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='006002' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='006003' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='006003' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004003' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='004003' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='004004' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='004004' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='008002' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='008002' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003006' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='003006' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='001035001' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='001035001' and rowid='505000089' DELETE FROM wf_bizflowinstancedetail where bizflowinstanceid in (select id from wf_bizflowinstance where bizentityid='003025' and rowid='505000089') DELETE FROM wf_bizflowinstance where bizentityid='003025' and rowid='505000089'