--Transaction (Process ID 84) was deadlocked on communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.--SELECT TOP 1 c.FilmID, f.Name AS FilmName, f.Year, f.IMDBCode, f.Rating, 0 AS Score, '' AS RatingType, f.StatusID, c.Comment, c.CommentID, u.NickName, u.Rank, u.Country, c.UserID, c.SubmitDate, c.LastSubmitDate, c.ApprovalDate, u.Reviews, u.Status, c.Votes, c.VotesThisWeek, 0 AS Flagged, (DateDiff(d, F.DateAdded, getdate())) AS ReviewDaysAgoAdded, 0 AS HaveIVotedOnThisReview, c.Considered, 1 AS RecentVotes, c.Pass AS ReviewPass, 1 AS RejectionID, 'X' AS Feedback, c.DeclineDate, '' AS ShortDeclineReason, '' AS DeclineReason, '1/1/1900' AS VoteDate, LastVoteDate, c.ReviewRank, c.ThisWeekReviewRank, c.FilmsTopReview, c.UsersTopReview, '' AS Explanation FROM Comments c JOIN Films f ON f.FilmID = c.FilmID JOIN Users u ON c.UserID = u.UserID WHERE 1=1 AND c.StatusID = 1 AND c.Votes > 5 ORDER BY NEWID()