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]
FROM [dbo].[TaskReviews] AS tr
WHERE tr.[TaskExecutionId] IN @TaskExecutionIds
