Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems
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