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


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

Enter Parameters

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