Q&A for people looking to improve their interpersonal communication skills
select postid as [Post Link] , crt.name -- , text -- , JSON_QUERY(text, '$.Voters') , cv.userid as [User Link] from posthistory ph inner join closereasontypes crt on crt.id = comment cross apply OPENJSON(JSON_QUERY(ph.text, '$.Voters')) with (userid int '$.Id') cv where posthistorytypeid = 10