# of active reviewers in the past year

SQL

select count(*) from
	(
      SELECT actor_name AS `Reviewer`,
      COUNT(*) as `Reviews`
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        WHERE log_timestamp BETWEEN 20220701000000 AND 20230701000000
        AND 
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND log_namespace = 0
      JOIN actor ON actor_id = log_actor
      JOIN user ON actor_user = user_id
      join user_groups on actor_user=ug_user
      where ug_group='patroller'
      GROUP BY reviewer
      HAVING `Reviews` > 4
) x;
SQL

Checking query status...
