0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for contractors and serious DIYers

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

fork query

edited mar 2

created may 9 21 anonymous