Dupes of a specific question

1

Please login or register to vote for this query.

(click on this box to dismiss)

Astronomy

Q&A for astronomers and astrophysicists

SELECT DISTINCT Posts.Id AS [Post Link], Posts.*
FROM Posts, PostHistory
WHERE
  Posts.PostTypeId = 1
  AND Posts.DeletionDate IS NULL
  AND Posts.ClosedDate IS NOT NULL
  AND PostHistory.PostId = Posts.Id
  AND PostHistory.PostHistoryTypeId = 10
  AND PostHistory.Comment in ('1', '101')
  AND JSON_VALUE(PostHistory.Text, '$.OriginalQuestionIds[0]')
    = ##QuestionId:int##
ORDER BY Posts.Id DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results