25 Most Downvoted Users

3

Please login or register to vote for this query.

(click on this box to dismiss)

Users with the most downvotes cast on their questions and answers

Software Quality Assurance and Testing Meta

Q&A about the site for software quality control experts, automation engineers, and software testers

SELECT TOP 25
  b.OwnerUserId AS [User Link],
  SUM(CASE WHEN a.VoteTypeId = 3 THEN 1 ELSE 0 END) AS DownVotes,
  SUM(CASE WHEN a.VoteTypeId = 3 THEN 1 ELSE 0 END) * 100 / COUNT(a.VoteTypeId) AS PctDownVotes,
  MIN(b.CreationDate) AS OldestPost,
  COUNT(DISTINCT b.Id) AS NumberOfPosts
FROM Votes a
  INNER JOIN Posts b
    ON 
      a.PostId = b.Id
      AND b.PostTypeId IN (1,2) -- Only questions and answers
WHERE 
  a.VoteTypeId IN (2,3) -- Only up and down votes
AND
  b.OwnerUserId > 0
GROUP BY b.OwnerUserId
HAVING COUNT(DISTINCT b.Id) > 15
ORDER BY SUM(CASE WHEN a.VoteTypeId = 3 THEN 1 ELSE 0 END) DESC

Enter Parameters

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