select wb.workflowname ,count(*) from  workflow_requestbase wr 
left join workflow_base wb on wb.id = wr.workflowid
left join (select DISTINCT requestid,operator from workflow_requestlog rl where rl.operator = '348566'
and rl.logtype =0 ) wrl  on wrl.requestid = wr.requestid
where 
wr.createdate BETWEEN '2023-12-01' and '2024-01-21'
AND wr.currentnodetype=3
and wb.SUBCOMPANYID = 207 
and  wb.isvalid=1 
and  wb.islockworkflow = 0 
and wb.workflowname not like '%无效%'
and wb.workflowname not like '%测试%'
and wb.workflowname not like '%巴黎%'
and wb.workflowname not like '%历史%'
and  wrl.operator = '348566'

group by wb.workflowname order by wr.requestid
limit 1000;