My most down-voted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sometimes posts can have very high scores but many downvotes. This query helps you find those.

Stack Overflow

Q&A for professional and enthusiast programmers

-- My most down-voted answers
-- Sometimes posts can have very high scores but many downvotes.  This query helps you find those.

SELECT
  COUNT(*) as Downvotes,
  Score + COUNT(*) as Upvotes,
  Posts.Score as Score,
  Posts.Id as [Post Link]
FROM
  Votes
INNER JOIN Posts ON Posts.Id = Votes.PostId
WHERE
  Posts.OwnerUserId = ##UserId##
  AND Votes.VoteTypeId = 3
GROUP BY Posts.Score, Posts.Id
ORDER BY Downvotes DESC, Upvotes DESC

Enter Parameters

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