Dupehammered questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT TOP 10 p.Id AS 'Post Link', p.Tags,
  h.CreationDate AS 'Close date',
  CAST(ca0.Value AS INT) AS 'Post Link',
  ca1.Value,
  CAST(ca2.Value AS INT) AS 'User Link',
  ca3.Value AS TagName
  FROM PostHistory AS h
  INNER JOIN Posts AS p ON h.PostId = p.Id
  CROSS APPLY (
    SELECT TOP 1 Value FROM OPENJSON(
      (SELECT Value FROM OPENJSON(h.Text) WHERE [Key] = 'OriginalQuestionIds')
    )
  ) AS ca0
  CROSS APPLY (
    SELECT Value FROM OPENJSON(
      (SELECT Value FROM OPENJSON(h.Text) WHERE [Key] = 'Voters')
    )
  ) AS ca1
  CROSS APPLY (
    SELECT Value FROM OPENJSON(ca1.VALUE) WHERE [Key] = 'Id'
  ) AS ca2
  CROSS APPLY (
    SELECT Value FROM OPENJSON(
      (SELECT Value FROM OPENJSON(ca1.VALUE) WHERE [Key] = 'BindingReason')
    ) WHERE [Key] = 'GoldTagBadge'
  ) AS ca3
  WHERE h.PostHistoryTypeId = 10 -- Close
    AND h.Comment = 101 -- Exact Duplicate
  ORDER BY h.CreationDate DESC

Enter Parameters

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