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

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT TOP 25
  b.OwnerUserId AS [User Link],
  SUM(CASE WHEN a.VoteTypeId = 3 THEN 1 ELSE 0 END) AS DownVotes,
  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
GROUP BY b.OwnerUserId
ORDER BY SUM(CASE WHEN a.VoteTypeId = 3 THEN 1 ELSE 0 END) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results