Recently deleted spam

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top ##number:int?100## 'site://posts/'+cast(p.Id as nvarchar)+'/revisions' as Post, p.CreationDate, p.DeletionDate
from PostsWithDeleted p
inner join Votes v on v.PostId = p.Id 
where v.VoteTypeId = 12 and p.DeletionDate is not null
group by p.Id, p.CreationDate, p.DeletionDate
order by p.DeletionDate desc

Enter Parameters

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