SELECT ud.DsName AS SOLICITANTE,
       pp.CodFlowExecute AS PROCESSO,
       titulo.DsFormFieldValue AS TITULO,
       area.DsFormFieldValue AS AREA,
       situacao_atual.DsFormFieldValue AS SITUACAO_ATUAL,
       sistema.DsFormFieldValue AS SISTEMA,
       descricao.DsFormFieldValue AS DESCRICAO,
       T.dstasktitle AS Tarefa,
       et.dtstartdate AS Inicio,
       et.dtenddate AS Conclusão,
       etp.dtendposition,
       CASE
           WHEN et.dsflowresult IS NULL
                AND sttaskactive = 'N' THEN 'Concluído'
           WHEN et.dsflowresult IS NULL
                AND sttaskactive = 'S' THEN 'Em Andamento'
           ELSE et.dsflowresult
       END AS Status,EMPRESA.DsFormFieldValue
FROM wfflow_execute PP
LEFT JOIN wdata dat ON dat.coddata = pp.coddata
LEFT JOIN wuser ud ON ud.coduser = dat.coduserowner
INNER JOIN wfflow np ON np.codflow = pp.codflow
LEFT JOIN wfflow_execute_task ET ON et.codflowexecute = PP.codflowexecute
LEFT OUTER JOIN dbo.wfflow_execute_task_position etp ON etp.codflow = et.codflow
AND etp.codflowexecutetask = et.codflowexecutetask
AND etp.codflowexecute = et.codflowexecute
AND etp.codtask = et.codtask
AND etp.codflowelement = et.codflowelement
AND Isnull(et.coduserexecute, etp.coduser) = etp.coduser
LEFT OUTER JOIN dbo.wftask t ON ET.codtask = t.codtask
LEFT OUTER JOIN dbo.wuser u ON Isnull(ET.coduserexecute, etp.coduser) = u.coduser
LEFT OUTER JOIN wfflow_form_field_log titulo ON titulo.codflowexecute = pp.codflowexecute
AND titulo.codfield IN (11633)
LEFT OUTER JOIN wfflow_form_field_log area ON area.codflowexecute = pp.codflowexecute
AND area.codfield IN (11686)
LEFT OUTER JOIN wfflow_form_field_log sistema ON sistema.codflowexecute = pp.codflowexecute
AND sistema.codfield IN (11687)
--LEFT OUTER JOIN wfflow_form_field_log empresa ON empresa.codflowexecute = PP.codflowexecute AND empresa.codfield IN (11686)
LEFT OUTER JOIN wfflow_form_field_log situacao_atual ON situacao_atual.codflowexecute = pp.codflowexecute
AND situacao_atual.codfield IN (11636)
LEFT OUTER JOIN wfflow_form_field_log descricao ON descricao.codflowexecute = pp.codflowexecute
AND descricao.codfield IN (11638)
WHERE pp.codflow IN (118)
AND PP.CodFlowExecute = 5795