Duplicates of deleted posts

1

Please login or register to vote for this query.

(click on this box to dismiss)

Bioinformatics

Q&A for researchers, developers, students, teachers, and end users interested in bioinformatics

SELECT TOP(##num?1000##)
  p.Id AS [Post Link],
  p.ClosedDate,
  pd.DeletionDate,
  'site://q/' + CAST(pl.RelatedPostId  AS varchar),  
  p.Score, p.ViewCount, p.Tags
FROM Postlinks pl INNER JOIN Posts p ON pl.PostId=p.Id
  INNER JOIN PostsWithDeleted pd ON pl.RelatedPostId=pd.Id
WHERE (pl.LinkTypeId=3) AND (p.PostTypeId=1) AND
  (p.ClosedDate IS NOT NULL) AND (pd.DeletionDate IS NOT NULL)
ORDER BY pd.DeletionDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results