How to use Data Explorer to find the most prolific closers on a site?

1

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackexchange.com/questions/242618/how-to-use-data-explorer-to-find-the-most-prolific-closers-on-a-site

Physics

Q&A for active researchers, academics and students of physics

;with closevoters as
(
select convert(int,json_value( 
        text, concat(
          '$.Voters[', 
          ind.value, 
          '].Id')
          )) as voterid
from posthistory ph
cross join string_split('0,1,2,3,4,5,6', ',') ind
where posthistorytypeid = 10 -- close event
)

select voterid as [User Link]
     , count(*) [# of posts closed]
from closevoters
where voterid is not null
group by voterid
order by count(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results