1

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 postid as [Post Link],
  concat('site://posts/',
        postid,
        '/revisions'
        ) [Revisions 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

fork query

edited jul 17 Martin20528

created mar 19 18 rene