What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

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?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

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.

share|improve this answer
    
What is the lag between the data explorer content and the live content (if any)? Just as a reference. –  Werner Jan 24 at 21:26
    
Cheers Mr. jon.doe6935, and it even show deleted posts! –  Shadow Wizard Jan 24 at 21:27
    
@Werner see here: The data is updated early every Monday morning around 3:00 UTC –  Shadow Wizard Jan 24 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 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 at 8:49
    
@psubsee2003 Worked now, it has to be switched to SO to search the MSO database. Thanks. –  herohuyongtao Jan 25 at 8:53

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: http://meta.stackexchange.com/questions/linked/[question id]

For example: http://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)

share|improve this answer
    
Worth noting: this will also get you all of the questions that are linked manually by someone, not just the duplicates. –  Robert Harvey Jan 24 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 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 Jan 24 at 21:19

You must log in to answer this question.

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