My suggested edit votes that got overruled

Please login or register to vote for this query.

(click on this box to dismiss)

Provides links to the suggested edits that you voted on, where the outcome went against your vote.

Q&A for programmers

-- My
-- Enter Query Description

DECLARE @UserId int = ##UserId##

SELECT edit.PostId, edit.Id as [Suggested Edit Link]
FROM SuggestedEditVotes vote, SuggestedEdits edit
WHERE vote.UserId = @UserId
AND vote.SuggestedEditId = edit.Id
AND (edit.ApprovalDate IS NOT NULL AND vote.VoteTypeId = 3
OR   edit.RejectionDate IS NOT NULL AND vote.VoteTypeId = 2);

created jan 9 12