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

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

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 main site
loading Hold tight while we fetch your results