Posts closed by the given user


Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

select postid as [Post Link],
        ) [Revisions Link]
     , ph.CreationDate
 --    , text
 --    , JSON_QUERY(text, '$.Voters')
     , cv.userid as [User Link]
from posthistory ph
inner join closereasontypes crt on = comment
cross apply OPENJSON(JSON_QUERY(ph.text, '$.Voters')) 
       with (userid int '$.Id') cv
where (posthistorytypeid = 10)
  AND (cv.userid=##UserId?8297##)
order by postid DESC

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results