SELECT tr.[Id],
       tr.[TaskExecutionId],
       tr.[ReviewerEmail],
       tr.[ReviewerId],
       tr.[Decision],
       tr.[Feedback],
       tr.[RequestedAt],
       tr.[RespondedAt],
       tr.[RespondedBy],
       tr.[ExpectedSlaDuration],
       tr.[SlaViolatedAt],
       tr.[IsLate],
       tr.[IsOverdue],
       tr.[ReviewerDisplayName],
       tr.[RespondedByDisplayName],
       tr.[IsHelpful],
       tr.[Flags],
       tr.[SuggestedPrompt],
       tr.[StrategyId],
       tr.[StrategyRating],
       tr.[StrategyComment],
       te.[Id] AS TaskExecutionSplit,
       te.*,
       wr.[Id] AS ReviewerSplit,
       wr.*
FROM [dbo].[TaskReviews] AS tr
    INNER JOIN [dbo].[TaskExecutions] AS te
ON te.[Id] = tr.[TaskExecutionId]
    LEFT JOIN [dbo].[WorkspaceReviewers] AS wr ON wr.[Id] = tr.[ReviewerId]

