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