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

Stack Overflow

Q&A for professional and enthusiast programmers

select top 100 PostId, Upvotes, Downvotes, 1000 * Upvotes / Downvotes as Ratio
from (
    select
        PostId, 
        Upvotes = sum(case when VoteTypeId = 2 then 1 else 0 end),
        Downvotes = sum(case when VoteTypeId = 3 then 1 else 0 end)
    from Votes
    where VoteTypeId in (2,3)
    group by PostId
) as VoteCounts inner join Posts on Posts.Id = VoteCounts.PostId
where CommunityOwnedDate is null
and ClosedDate is null
and DeletionDate is null
and Upvotes > Downvotes
and Downvotes > 0
order by Upvotes desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results