0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers building blockchains with the Substrate SDK

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 nov 28

created may 9 21 anonymous