SELECT sub.SUBJ_NAME as SUBJECT_AREA

,wkfltask.TASK_NAME as WORKFLOW_NAME

,sesstask.TASK_NAME AS SESSION_NAME

, A.TASK_TYPE_NAME,A.ATTR_NAME

, A.ATTR_VALUE AS CONNECTION_STRING

FROM REP_TASK_ATTR A, OPB_SUBJECT sub

JOIN OPB_TASK wkfltask

       ON sub.SUBJ_ID = wkfltask.SUBJECT_ID

       AND wkfltask.task_type = 71

JOIN OPB_TASK sesstask

       ON sub.SUBJ_ID = sesstask.SUBJECT_ID

       AND wkfltask.TASK_ID = sesstask.RU_PARENT_ID

       AND sesstask.TASK_TYPE = 68

WHERE A.TASK_ID=sesstask.TASK_ID

and a.ATTR_ID in (7,8)

AND sub.SUBJ_NAME IN( ' Folder Name') and

wkfltask.TASK_NAME IN ( 'Workflow name')

ORDER BY 2,3