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

Q&A for users and developers of hardware and software for Raspberry Pi

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

-- p.CommunityOwnedDate is null and p.ClosedDate is null
select top 100 p.id as [Post Link], u.DisplayName, up, down from @VoteStats 
join Posts p on PostId = p.Id
join Users u on p.OwnerUserId = u.Id
where down > (up * 0.25)
order by up desc

fork query

edited aug 22 13 jon.doe11767

created may 20 10 sam.saffron