Q&A for people looking to bypass life's everyday problems with simple tricks
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, p.CreationDate as CreationDate 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