Most controversial posts on the site


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

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

select PostId, Upvotes, Downvotes
from (
    select PostId, Upvotes, Downvotes, 2.0 * Downvotes / nullif(Upvotes, 0) as Ratio
    from (
            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 OwnerUserId = 507738
    and Upvotes > 0
    and Downvotes > 0
) as Scores

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results