Most close votes


Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

;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 sites:
loading Hold tight while we fetch your results