select WORKFLOWNAME,
       wn.NODENAME,
       js.ROLESNAME,
       wb.SUBCOMPANYID,
       wb.id,
       wb.ISVALID,
       wn.nodename,
       (case when wb.version is null then 1 else wb.version end) as version
from (select GROUPID,
             OBJIDfrom workflow_groupdetailwhere TYPE = 2and OBJID in(select id from hrmroles where SUBCOMPANYID = 389)) gpleft
         join workflow_nodegroup gi on gi.id = gp.GROUPIDleft
         join workflow_flownode wf on wf.NODEID = gi.NODEIDleft
         join workflow_nodebase wn on wn.id = wf.NODEIDleft
         join workflow_base wb on wb.id = wf.WORKFLOWIDleft
         join hrmroles js on js.id = gp.OBJIDwhere wb.SUBCOMPANYID = 389