SELECT g.[Id],
       g.[WorkspaceId],
       g.[Name],
       g.[TaskType],
       g.[IncludePool],
       m.[ReviewerGroupId],
       m.[WorkspaceReviewerId],
       wr.[Id] AS ReviewerSplit,
       wr.*
FROM [dbo].[ReviewerGroups] AS g
    LEFT JOIN [dbo].[ReviewerGroupMemberships] AS m
ON m.[ReviewerGroupId] = g.[Id]
    LEFT JOIN [dbo].[WorkspaceReviewers] AS wr ON wr.[Id] = m.[WorkspaceReviewerId]
WHERE g.[WorkspaceId] = @WorkspaceId
ORDER BY g.[Name], wr.[DisplayName]
