1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

SELECT TOP ##number?500##
  Id,
  url = 'site://q/' + CAST(Id AS varchar),
  CreationDate, DeletionDate, Score, ViewCount, Tags
FROM PostsWithDeleted
WHERE (PostTypeId = ##type?1##) and (Deletiondate IS NOT NULL)  
ORDER BY DeletionDate DESC

fork query

created may 29 23 Martin20528