Posts closed by the given user


Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

select postid as [Post Link],
        ) [Revisions Link]
 --    , 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 sites:
loading Hold tight while we fetch your results