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.

Q&A for people looking to bypass life's everyday problems with simple tricks

-- 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

fork query

created may 16 11 Renesis