Duplicates for a given post

1

Please login or register to vote for this query.

(click on this box to dismiss)

Arqade

Q&A for passionate videogamers on all platforms

select PostId as [Post Link],
  PostLinks.CreationDate,
  ViewCount,
  AnswerCount
from PostLinks
JOIN Posts on Posts.Id=PostLinks.PostId
where RelatedPostId=##OriginalPostId##
and LinkTypeId=3 -- duplicate
ORDER BY PostLinks.CreationDate DESC

Enter Parameters

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