SELECT dsa.Status                      AS StatusCode,
       dsb.Id,
       dsl.UserId,
       dsl.Timestamp,
       wf.Name                         AS WorkflowName,
       Coalesce(u.Name, 'CompanyName') AS `Username`
FROM   DataSource dsa,
       Workflow wf
       INNER JOIN DataSource dsb
         ON wf.Id = dsb.WorkflowId
            AND dsb.Id IN ( 0, 1, 2, 3,
                            4, 5, 6, 7 )
            AND dsb.Status = '203'
             OR dsb.Status = '204'
       INNER JOIN DataSourceActivityLog dsl
         ON dsl.DataSourceId = dsa.Id
            AND dsl.DataSourceId = dsb.Id
            AND dsl.UserId = 1
            AND dsl.Timestamp = (SELECT Max(t2.Timestamp)
                                 FROM   DataSourceActivityLog AS dslt
                                 WHERE  dslt.DataSourceId = dsl.DataSourceId)
       LEFT JOIN User u
         ON u.Id = dsl.UserId
GROUP  BY dsl.Id
ORDER  BY dsl.Timestamp DESC