10

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?

6

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.

9
  • 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! Jan 24 '14 at 21:27
  • @Werner see here: The data is updated early every Monday morning around 3:00 UTC 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? 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. Jan 25 '14 at 8:49
  • @psubsee2003 Worked now, it has to be switched to SO to search the MSO database. Thanks. 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
3

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)

3
  • 1
    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. 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 .