select we.id,
       wb.id as           workflowid,
       wt.typename,
       wb.workflowname,
       we.TRIGGERNAMEfrom Workflow_DataInput_entry we left join Workflow_DataInput_main wm
on we.id = wm.entryid left join Workflow_DataInput_field wf on wf.DataInputID = wm.id left join workflow_base wb on wb.id = we.WORKFLOWID left join workflow_type wt on wt.id = wb.workflowtypewhere we.WORKFLOWID in ( select id from workflow_base where SUBCOMPANYID = 101 and ISVALID = 1 ) AND wf.DBFIELDNAME = 'gsfzr'