Find duplicates of deleted posts.

4

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT
  PostLinks.PostId as [Post Link]
FROM
  PostLinks
WHERE
  PostLinks.LinkTypeId = 3 AND
  (SELECT
     Posts.Id
   FROM
     Posts
   WHERE
     Posts.Id = PostLinks.PostId
     ) IS NOT NULL AND
  (SELECT
     Posts.Id
   FROM
     Posts
   WHERE
     Posts.Id = PostLinks.RelatedPostId
     ) IS NULL
GROUP BY PostLinks.PostId
ORDER BY PostLinks.PostId

Enter Parameters

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