electronics dataset

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology Meta

Q&A about the site for enthusiasts and scholars of mythology and folklore

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results