Deleted Questions with Score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

declare @VoteStats table (PostId int, up int, down int, Ddate datetime)
insert @VoteStats
select
    p.Id,
    up = sum(case when VoteTypeId = 2 then 1 else 0 end),
    down = sum(case when VoteTypeId = 3 then 1 else 0 end),
    p.DeletionDate
from Votes v join PostsWithDeleted p on v.postid = p.id
where v.VoteTypeId in (2,3)
and p.DeletionDate is not null
and p.PostTypeId = 1
group by p.Id, p.DeletionDate

select 'site://q/' + CAST(PostId AS nvarchar) AS [Post],
(up - down) as [Score], Convert(VARCHAR,Ddate,102) as [Deleted Date]
from @VoteStats vs
order by [Score] asc

Enter Parameters

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