统计一下今年某人一共审核了多少廉洁协议

select count(id) from workflowbase where isdelete=0 and id in(
select workflowid from workflowlog where operator in('4028e5e55f6dfac3015f7be47a9f6efb','4028e5e581323a150181f7fda29867c3','4028e5e55bc9d5e1015bcbec1e2203f7','4028e5e58872768101889f8ffa8811f0') 
and logtype='402881e50c5b4646010c5b5afd17000a'
and workflowid in(
select requestid from ufq2e1t21479626212788 where field040='40288110301fdb1601301fedb6080096'
)
union all
select workflowid from workflowlogfinished where operator in('4028e5e55f6dfac3015f7be47a9f6efb','4028e5e581323a150181f7fda29867c3','4028e5e55bc9d5e1015bcbec1e2203f7','4028e5e58872768101889f8ffa8811f0') 
and logtype='402881e50c5b4646010c5b5afd17000a'
and workflowid in(
select requestid from ufq2e1t21479626212788 where field040='40288110301fdb1601301fedb6080096'
)
)

posted @ 2025-08-06 10:37  java璀璨小菜鸟  阅读(8)  评论(0)    收藏  举报