0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT TOP 10 h.PostId AS [Post Link], h.CreationDate, ca.Value
  FROM PostHistory AS h
  CROSS APPLY (
    --SELECT Value FROM OPENJSON(
      SELECT Value FROM OPENJSON(
        (SELECT Value FROM OPENJSON(h.Text) WHERE [Key] = 'Voters')
      )
    --) WHERE [Key] = 'Id'
  ) ca
  WHERE h.PostHistoryTypeId = 10 -- Close
    AND h.Comment = 101 -- Exact Duplicate
  ORDER BY h.CreationDate DESC

view current version

edited jul 18 19

created jul 18 19 Glorfindel