SELECT ae.[Id],
       ae.[TaskReviewId],
       ae.[ReviewerEmail],
       ae.[ReviewerDisplayName],
       ae.[Decision],
       ae.[Timestamp], ae.[Feedback], ae.[Notes], ae.[StrategyId], ae.[StrategyRating], ae.[StrategyComment], tr.[Id] AS TaskReviewSplit, tr.*, te.[Id] AS TaskExecutionSplit, te.*, wr.[Id] AS ReviewerSplit, wr.*
FROM [dbo].[ReviewAuditEvents] AS ae
    INNER JOIN [dbo].[TaskReviews] AS tr
ON tr.[Id] = ae.[TaskReviewId]
    INNER JOIN [dbo].[TaskExecutions] AS te ON te.[Id] = tr.[TaskExecutionId]
    LEFT JOIN [dbo].[WorkspaceReviewers] AS wr ON wr.[Id] = tr.[ReviewerId]

