query looks like this: SELECT * FROM WorkflowTaskInstance wti LEFT JOIN WorkflowInstance wi on wti.WorkflowInstanceGuid = wi.Guid LEFT JOIN WorkflowUserGroups wug on wti.GroupId = wug.GroupId WHERE wi.NodeId = @0 AND wti.CompletedDate IS NULL ORDER BY wti.Id DESC