Fiwiki FlaggedRevs 2020 reviewers by activity level

SQL

use fiwiki_p;
select 
	sum(1) as c, 
    a.actor_name, 
    group_concat(l.log_action) as log_actions, 
    l.log_type 
from 
	logging_userindex as l, 
    actor_logging as a, 
    (select ug_user as user_id from user_groups where ug_group IN ('sysop', 'editor', 'reviewer') 
     UNION select ufg_user as user_id from user_former_groups where ufg_group IN ('sysop', 'editor', 'reviewer')
    ) as ug 
where 
	a.actor_user=ug.user_id 
    and l.log_actor=a.actor_id 
    and l.log_type='review' 
    and log_id>11602246 and log_timestamp>20200023051813 
    and log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i', 'unapprove', 'unapprove2') 
group by actor_id 
order by c desc

SQL

Checking query status...