Can I see how many duplicates there are of a post? I.e. how many posts have been labelled as duplicate because of this post? If so, how? And can I also get a list of these duplicated posts?


The most reliable way to do this is to use the Data Explorer:

select PostId as [Post Link]
from PostLinks
where RelatedPostId=##OriginalPostId##
and LinkTypeId=3 -- duplicate

This will give you both a total count for questions closed as duplicates of a given original post, and links to all of the ones that haven't been deleted yet.

  • What is the lag between the data explorer content and the live content (if any)? Just as a reference. – Werner Jan 24 '14 at 21:26
  • Cheers Mr. jon.doe6935, and it even show deleted posts! – Shadow Wizard is Vaccinating Jan 24 '14 at 21:27
  • @Werner see here: The data is updated early every Monday morning around 3:00 UTC – Shadow Wizard is Vaccinating Jan 24 '14 at 21:28
  • I just tested with postId=213000 which does have duplicate posts, but turns out nothing. What did I miss? – herohuyongtao Jan 25 '14 at 6:55
  • @herohuyongtao works for me. You probably forgot to switch sites. The query Shog references defaults to SO. You have to click on the MSO icon next to "switch sites" under the Run Query" button to get it to search the MSO database. – psubsee2003 Jan 25 '14 at 8:49
  • @psubsee2003 Worked now, it has to be switched to SO to search the MSO database. Thanks. – herohuyongtao Jan 25 '14 at 8:53
  • the query returns nothing for me e.g., there are several duplicates for SO/q/13047806 question but there are no results if I put 13047806 as OriginalPostId. – jfs Apr 5 '15 at 13:14
  • Only one duplicate of that question right now, @jfsebastian - and that's too new to have made it into the public data yet. Try it again Monday. – Shog9 Apr 5 '15 at 16:09
  • I've spoken too soon. There is indeed only one duplicate of the given question. And it is too new to appear in Data Explorer. – jfs Apr 5 '15 at 18:21

There is a record on all linked questions, both linked from the given question to others and vice versa. You can see the full list by directly browsing to this URL: https://meta.stackexchange.com/questions/linked/[question id]

For example: https://meta.stackexchange.com/questions/linked/194476

All questions marked [duplicate] are duplicates of the question having the ID in the URL.

If you're already in a question page there is "Linked" section when there are any linked posts:

And "see more linked questions…" when there are more than 10. (leading to the above page)

  • Worth noting: this will also get you all of the questions that are linked manually by someone, not just the duplicates. – user102937 Jan 24 '14 at 21:15
  • Sorry, but this does not work. This includes some posts that are duplicates but not of the source post. Linked posts include any posts that reference the source. – Werner Jan 24 '14 at 21:16
  • @Robert true, that's why I suggested visiting the page with all linked questions and those marked duplicate can be assumed to be duplicates of the question at hand. – Shadow Wizard is Vaccinating Jan 24 '14 at 21:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .