SELECT wb.id,
       wb.WORKFLOWNAME,
       wt.TYPENAME,
       wgd.TYPE,
       hc.SUBCOMPANYNAMEFROM(SELECT *  FROM workflow_base  WHERE SUBCOMPANYID = 101  AND ISVALID = 1  AND WORKFLOWTYPE NOT IN ( 1,171,89,105,223)) AS wb LEFT JOIN workflow_flownode wf
ON wf.WORKFLOWID = wb.Id AND NODETYPE = 0 LEFT JOIN workflow_nodegroup wng ON wng.NODEID = wf.NODEID LEFT JOIN workflow_groupdetail wgd ON wgd.GROUPID = wng.ID AND TYPE IN (30 ,4) LEFT JOIN hrmsubcompany hc ON wgd.OBJID = hc.id LEFT JOIN workflow_type wt ON wt.id = wb.WORKFLOWTYPE
WHERE TYPE IS NOT NULL