a1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

set statistics io, time on

CREATE TABLE #VoteStats (PostId int primary key, 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

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

DROP TABLE #VoteStats

Enter Parameters

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