Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement