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?
Add a comment
|
2 Answers
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.– WernerCommented Jan 24, 2014 at 21:26
-
Cheers Mr. jon.doe6935, and it even show deleted posts! Commented Jan 24, 2014 at 21:27
-
@Werner see here: The data is updated early every Monday morning around 3:00 UTC Commented Jan 24, 2014 at 21:28
-
I just tested with
postId=213000which does have duplicate posts, but turns out nothing. What did I miss? Commented Jan 25, 2014 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. Commented Jan 25, 2014 at 8:49
-
@psubsee2003 Worked now, it has to be switched to SO to search the MSO database. Thanks. Commented Jan 25, 2014 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
13047806asOriginalPostId.– jfsCommented Apr 5, 2015 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.– Shog9Commented Apr 5, 2015 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.– jfsCommented Apr 5, 2015 at 18:21
There is a record of 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
Questions marked [duplicate] may be 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)
answered Jan 24, 2014 at 21:14
-
2Worth noting: this will also get you all of the questions that are linked manually by someone, not just the duplicates.– user102937Commented Jan 24, 2014 at 21:15
-
1Sorry, 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.– WernerCommented Jan 24, 2014 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. Commented Jan 24, 2014 at 21:19
-
Since this is being used as a duplicate target, perhaps add a note about links in comments being one source of "linked", duplicates being the other? Perhaps backed up by the canonical MSO post about it (e.g., the announcement of it by Atwood). Commented Jan 19, 2022 at 13:34
-
@This_is_NOT_a_forum well I did write "linked from the given question" which means links posted in the question or its comments. Comment with link to other question won't cause the question where the comment was posted to appear in the Linked Questions of the other question, as far as I know. Unless you think it's wrong? Commented Jan 20, 2022 at 6:16