Most controversial posts on the site

0

Please login or register to vote for this query.

(click on this box to dismiss)

Looks for posts with more than half the amount of downvotes as they have upvotes Ordered by upvotes

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

set nocount on 

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

insert @VoteStats
select
    PostId, 
    up = sum(case when VoteTypeId = 2 then 1 else 0 end), 
    down = sum(case when VoteTypeId = 3 then 1 else 0 end),
    
    ratio = (
    (sum(case when VoteTypeId = 3 then 1 else 0 end)*10000) / 
    
    (sum(case when VoteTypeId = 2 then 1 else 0 end)*100 + sum(case when VoteTypeId = 3 then 1 else 0 end)*100  )
    
    )
    
    
    
from Votes
where VoteTypeId in (2,3)
group by PostId

set nocount off


select  p.id as [Post Link] , up, down, ratio from @VoteStats 
join Posts p on PostId = p.Id
where down > (up * 0.5) and p.CommunityOwnedDate is null and p.ClosedDate is null
order by ratio desc

Enter Parameters

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