SELECT wf.WORKFLOWID AS workflowid,
       wb.WORKFLOWNAME,
       wn.id         AS nodeid,
       wn.NODENAME,
       wt.NODEPASSHOUR,
       wt.isusedFROM    workflow_base wb LEFT JOIN workflow_flownode wf
ON wb.id = wf.WORKFLOWID LEFT JOIN workflow_nodebase wn ON wf.NODEID = wn.id LEFT JOIN workflow_nodeovertime wt ON wt.NODEID = wn.id
WHERE WB.ISVALID = 1 AND wb.SUBCOMPANYID = 101 and ( wt.NODEPASSHOUR <>24 or wt.isused = 0)