When my Suggested Edit decisions were reversed

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

DECLARE @UserId int = ##UserId##

SELECT TOP 1000 SE.PostId as [Post Link], V.Name as [Vote Type], SE.ApprovalDate, SE.RejectionDate
FROM SuggestedEditVotes SEV
INNER JOIN SuggestedEdits SE
ON SEV.SuggestedEditId = SE.Id
INNER JOIN VoteTypes V
ON V.Id = SEV.VoteTypeId
WHERE SEV.UserId = @UserId
AND ((SEV.VoteTypeId = 2 AND RejectionDate IS NOT NULL)
    OR (SEV.VoteTypeId = 3 AND ApprovalDate IS NOT NULL))
ORDER BY SEV.ID DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results