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


Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

;with closevoters as
select convert(int,json_value( 
        text, concat(
          )) 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

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