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


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.

You must log in to answer this question.

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