0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

Select top 1000 
p.id as [Post Link], p.Score, 
'https://stackoverflow.com/q/'+cast(p.id as varchar(11))+'',
p.*
FROM PostsWithDeleted  p
WHERE p.PostTypeId = 2
and p.DeletionDate IS NOT NULL
order by P.Score desc

fork query

edited jan 30 20

created jan 30 20 Jerry29498