1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select 'site://questions/' + CAST(Id AS nvarchar) as [Post Link], CreationDate, DeletionDate, Score
from postswithdeleted
where score < 0
and posttypeid = 1
and deletiondate is not null
order by DeletionDate DESC

fork query

edited apr 27 17

created apr 27 17 Jeff Schaller