Most Down-Voted Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 20 questions with the most down-votes (ignores up-votes)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

-- Most Down-Voted Questions
-- The top 20 questions with the most down-votes (does NOT ignore up-votes)

with vote_counts as
(
  select postid
  , sum ( case when VoteTypeId=2 then 1 when VoteTypeId=3 then -1 else 0 end ) vcnt
  from votes 
  group by postid
)

select top 20 vcnt as 'Net Vote Count', v.postid AS [Post Link],p.body
from vote_counts v 
inner join posts p on p.id=v.postid
where PostTypeId = 1 
order by vcnt asc

Enter Parameters

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