Most controversial downvoted answers on the site


Please login or register to vote for this query.

(click on this box to dismiss)

Looks for answers with more downvotes than upvotes Ordered by upvotes

Stack Overflow

Q&A for professional and enthusiast programmers

set nocount on 

declare @VoteStats table (PostId int, up int, down int) 

insert @VoteStats
    up = sum(case when VoteTypeId = 2 then 1 else 0 end), 
    down = sum(case when VoteTypeId = 3 then 1 else 0 end)
from Votes
where VoteTypeId in (2,3)
group by PostId

set nocount off

select top 100 as [Post Link] , up, down, p.Score, (CASE WHEN p.Id = question.AcceptedAnswerId
    THEN 'yes'
   ELSE 'no' END) from @VoteStats 
join Posts p on PostId = p.Id
inner join Posts question on p.ParentId=question.Id
where p.Score<0 and p.CommunityOwnedDate is null and p.ClosedDate is null and p.PostTypeId = 2
order by up desc

Enter Parameters

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