The example below is will give you the current task for all in process workflows based on workflow title.
select '!~<a href="/livelink/llisapi.dll?func=work.statusheader&workid=' || work_workid || '&subworkid=' || work_workid || '">' || subwork_title || '</a>' as "Workflow Overview", a.wf_valstr "CompanyCode", SUBWORK_TITLE as "Workflow", SUBWORKTASK_TITLE as "Current Step", SUBWORKTASK_DATEREADY as "Step Start Date", WORK_OWNERID_NAME, SUBWORKTASK_PERFORMERID_NAME as "Assigned To" from todo, wfattrdata a where subwork_title like '%%<workflow title>' and (a.wf_id =work_workid and a.wf_attrid = 6) order by a.wf_valstr ASC