Find reverse duplicates

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

--Target: Post ID for the target question.

SELECT
  Source.Id,
  Source.Id AS [Post Link],
  Source.OwnerUserId AS [User Link],
  Source.Score,
  Source.Tags,
  Source.CreationDate,
  PostLinks.CreationDate AS DuplicateDate
FROM PostLinks 
LEFT JOIN Posts AS Source ON Source.Id = PostLinks.PostID
LEFT JOIN Posts AS Target ON Target.ID = PostLinks.RelatedPostID 
WHERE
  PostLinks.LinkTypeId = 3 AND
  Target.ID = ##Target:int##

Enter Parameters

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