SELECT DISTINCT
	a.REQUESTID,
	wr.REQUESTNAME AS 流程标题,
	b.LASTNAME AS 操作人,
	wb.WORKFLOWNAME AS 流程名称,
	wn.NODENAME AS 节点名称,
    a.OPERATEDATE AS 操作日期
FROM
	( SELECT REQUESTID, USERID, OPERATEDATE, WORKFLOWID, NODEID FROM workflow_currentoperator WHERE USERID IN (381255) ) a
	LEFT JOIN hrmresource b ON b.ID = a.USERID
	LEFT JOIN workflow_base wb ON wb.id = a.WORKFLOWID
	LEFT JOIN workflow_nodebase wn ON wn.ID = a.NODEID
	LEFT JOIN workflow_requestbase wr ON wr.REQUESTID = a.REQUESTID
    where a.OPERATEDATE BETWEEN '2023-12-01' and '2024-01-19'
ORDER BY
	wb.WORKFLOWNAME 
limit 601,6000;