Q&A for SharePoint enthusiasts
SELECT p.Id AS pId, p.Title as pTitle, p.Body as pBody, pd.Id as pdId, pd.Title as pdTitle, pd.Body as pdBody FROM PostHistory ph JOIN Posts p ON p.Id = ph.PostId JOIN Posts pd ON pd.Id = CAST(JSON_VALUE(ph.Text, '$.OriginalQuestionIds[0]') AS nvarchar) WHERE p.PostTypeId = 1 -- Question AND ph.PostHistoryTypeId = 10 -- Close event AND ph.Comment = 101 -- Dupe