Retrieving a list of questions closed as duplicates [duplicate]

Question

I couldn't find any way to get, through the API, a list of all questions that are duplicate of what other question.

For example, for the question with ID 10369, I want to obtain the question with ID 10372 (or the other way around, at least).

Is there a way to do so, other than scraping the page?

Answer 1

Here's an example you can work with:

SELECT TOP 10 
  PostId,
  [Dupe(s)] = SUBSTRING(Text,CHARINDEX('[',Text),CHARINDEX(']',Text)-CHARINDEX('[',Text)+1)
FROM dbo.PostHistory 
WHERE PostHistoryTypeID = 10 -- closed question
AND Text LIKE '{"OriginalQuestionIds":%'
--AND PostId IN (your list)

I put TOP 10 so the query returns quickly. If you don't use TOP the query will likely timeout. You can remove that entirely if your list is reasonable.

Answer 2

You can use the data dump and write your own queries, I don't think there currently exists a way to do it via SO.