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.

Q&A for those who study, teach, research and apply economics and econometrics

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]

fork query

edited sep 12 12

created sep 12 12 Gilles