reviewed by non-patrollers

SQL

# List of all patrollers and admins
#SELECT DISTINCT `ug_group` FROM `user_groups`;

SELECT actor_name, COUNT(logging.log_page) as num
FROM logging JOIN actor ON log_actor = actor_id
JOIN page ON page_id = log_page
JOIN user_groups ON  ug_user = actor_user
WHERE actor_user NOT IN (
  SELECT ug_user
  FROM user_groups 
  WHERE ug_group IN ('patroller', 'sysop')
)
AND page_is_redirect = 0
AND log_action = 'reviewed' 
AND log_type = 'pagetriage-curation'
AND log_timestamp > (NOW() - INTERVAL 1 MONTH)
AND log_namespace = 0 
GROUP BY actor_name
ORDER BY COUNT(logging.log_page) DESC
SQL

Checking query status...
