8

Please login or register to vote for this query.

(click on this box to dismiss)

See the suggested edits where I voted to approve but that were rejected, or vice versa. 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/79860/my-contested-suggested-edit-reviews for the suggested edits where my vote carried the decision.

Q&A about the site for Joomla! administrators, users, developers and designers

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

fork query

edited sep 12 12

created sep 12 12 Gilles