2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT c.PostId AS [Post Link]
  FROM PostHistory AS c
  CROSS APPLY OPENJSON(c.Text, '$.Voters') AS v
  WHERE c.PostHistoryTypeId = 10 -- Post Closed
    AND JSON_VALUE(v.Value, '$.Id') = ##UserId:int##

view current version

edited feb 28

created feb 28 Glorfindel