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

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

--set nocount on 

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

--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)
--from Votes
--where VoteTypeId in (2,3)
--group by PostId

--set nocount off


select top 100000 title, body, Tags, Score, ViewCount, AnswerCount, CommentCount, FavoriteCount from Posts 
--join Posts p on PostId = p.Id
where PostTypeId = 1
--where down > (up * 0.5) and p.CommunityOwnedDate is null and p.ClosedDate is null
--order by up desc

Enter Parameters

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