select 'site://q/' + CONVERT(varchar(20), q.Id) as Link, ...

1

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

select 'site://q/' + CONVERT(varchar(20), q.Id) as Link, 
q.Score as QuestionScore, a.Score as AnswerScore, q.DeletionDate as DeletionDate
from PostsWithDeleted a
inner join PostsWithDeleted q on a.ParentId = q.Id
where a.DeletionDate is not null and a.PostTypeId = 2
and q.DeletionDate is not null and a.DeletionDate >= q.DeletionDate
and q.ClosedDate is null and q.Score < 0 and a.Score > 0
order by q.DeletionDate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results