Users who participated in close, reopen, (un)delete, (un)lock, (un)protect, migrate

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- any user who participated in succesfully 
-- closing, reopening, (un)deleting, (un)locking, (un)protecting, migrating

select voters.id [User Link] 
     , count(*) [# attributed moderation] 
from posthistory
cross apply openjson(text, '$.Voters') with ( Id int '$.Id') voters
inner join users on users.id = voters.id
where posthistorytypeid in ( 10,11,12,13,14,15,19,20,35)
and voters.id > 0
group by voters.id
order by count(*) desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results