Questions with the most downvotes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics Meta

Q&A about the site for people studying math at any level and professionals in related fields

SELECT TOP(##num?100##)
  'site://q/' + CAST(v.PostId AS varchar) AS [url],
  v.PostId AS [Post Link],
  SUM(Case When v.VoteTypeId = 3 Then 1 Else NULL End) AS DownVotes,
  SUM(Case When v.VoteTypeId = 2 Then 1 Else NULL End) AS UpVotes,
  p.Score, p.ViewCount, p.Tags
FROM Votes v INNER JOIN PostsWithDeleted p ON v.PostId=p.Id
WHERE (p.PostTypeId=1) ---only questions
GROUP BY v.PostId, p.Score, p.ViewCount, p.Tags
ORDER BY DownVotes DESC

Enter Parameters

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