I am curious to see a list with the question that were marked as duplicate of my questions.

Maybe a SQL script? Other ways?


Questions posted by me: A, B

Question posted by others: C, D, E, F

C is duplicate of A. D and E are duplicates of B

The script should return C, D, E


1 Answer 1


The following data explorer query shows all posts that were marked as duplicates of questions you asked:

SELECT pl.PostId AS [Post Link]
FROM PostLinks pl
JOIN Posts q ON pl.RelatedPostId = q.Id
pl.LinkTypeId = 3
AND q.OwnerUserId = ##UserId##

I've put an updated version of this query on data.stackexchange.com, producing a sorted listing of duplicates and your questions that they were closed as duplicates of.

  • I would love to have this feature, not just for my question, but for any questions. This could be very useful if one want to look up for more insights.
    – zyy
    Commented Jan 26, 2021 at 1:48

You must log in to answer this question.

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