Users with the most rejected suggested edits

1

Please login or register to vote for this query.

(click on this box to dismiss)

See who floods the Suggested Edits review queue with useless edits

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP ##Limit:int?100##
  Users.Id [User Link],
  COUNT(*) [Total],
  SUM(CASE WHEN SuggestedEdits.ApprovalDate IS NOT NULL THEN 1 ELSE 0 END) [Accepted],
  SUM(CASE WHEN SuggestedEdits.RejectionDate IS NOT NULL THEN 1 ELSE 0 END) [Rejected],
  ROUND(SUM(CASE WHEN SuggestedEdits.RejectionDate IS NOT NULL THEN 1 ELSE 0 END) * 1.0 / COUNT(*) * 100, 2) [Rejected %]
FROM Users, SuggestedEdits
WHERE  
      Users.Id = SuggestedEdits.OwnerUserId
  AND Users.Id > 0
  AND SuggestedEdits.CreationDate >= DATEADD(dd, -##MaxAgeDays:int?28##, GETDATE())
GROUP BY Users.Id
HAVING
      COUNT(*) >= ##MinSuggestedEdits:int?5##
  AND SUM(CASE WHEN SuggestedEdits.RejectionDate IS NOT NULL THEN 1 ELSE 0 END) >= ##MinRejectedEdits:int?3##
ORDER BY Rejected DESC, Total DESC

Enter Parameters

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