My contested suggested edit reviews

3

Please login or register to vote for this query.

(click on this box to dismiss)

See the suggested edits where the decision went in the same direction as my vote, but there was an opposing vote. Note that this query only makes sense on Stack Overflow, which requires two concurring votes to approve or reject a suggested edit. See also http://data.stackexchange.com/stackoverflow/query/79859/my-overruled-suggested-edit-reviews for the suggested edits where my vote did not carry the decision.

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT
  s.PostId AS [Post Link],
  'site://suggested-edits/' + Cast(s.Id AS VarChar(20)) AS [Suggested Edit],
  CASE v0.VoteTypeId WHEN 2 THEN 'approved' ELSE 'rejected' END AS [Direction],
  s.CreationDate AS [Date]
FROM SuggestedEditVotes v0, SuggestedEditVotes v1, SuggestedEditVotes v2,
     SuggestedEdits s
WHERE v0.UserId = ##User##
  AND v0.SuggestedEditId = s.Id
  AND v1.SuggestedEditId = s.Id
  AND v2.SuggestedEditId = s.Id
  AND v0.VoteTypeId = v1.VoteTypeId
  AND v0.Id <> v1.Id
  AND v0.VoteTypeId <> v2.VoteTypeId
ORDER BY [Date]

Enter Parameters

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