1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select S.Id as [Post Link], T.Id as TargetId, T.CreationDate, T.DeletionDate
from PostLinks L
inner join PostsWithDeleted T on T.Id = L.RelatedPostId
inner join Posts S on S.Id = L.PostId
inner join Posts SA on SA.ParentId = S.Id
where SA.OwnerUserId = ##SourceAnswererId##
  and T.DeletionDate is not null
order by T.DeletionDate desc

fork query

edited aug 20 18

created aug 20 18 dpld