SELECT wr.[Id],
       wr.[WorkspaceId],
       wr.[Email],
       wr.[DisplayName],
       wr.[IsActive],
       wr.[TimeZone],
       wr.[AvailabilityStart],
       wr.[AvailabilityEnd],
       wr.[VacationStart],
       wr.[VacationEnd],
       wr.[IsOutOfOffice],
       ra.[Id] AS AvailabilitySplit,
       ra.*
FROM [dbo].[WorkspaceReviewers] AS wr
    LEFT JOIN [dbo].[ReviewerAvailabilities] AS ra
ON ra.[ReviewerId] = wr.[Id]
WHERE wr.[WorkspaceId] = '27b801bd-0f4c-4ff4-94a4-0303c7a8626a'
  AND wr.[IsActive] = 1
ORDER BY wr.[DisplayName]
