2021 NPP reviews of non-redirects

SQL

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
#AND actor_name IN ('Vexations', 'Rosguill', 'Mccapra')
AND ug_group = 'patroller'
AND page_is_redirect = 0
AND log_action = 'reviewed' 
AND log_type = 'pagetriage-curation'
AND 202012312359 < log_timestamp < 202201010000
# AND log_timestamp  > (NOW() - INTERVAL 1 WEEK)
AND log_namespace = 0 
GROUP BY actor_name
ORDER BY COUNT(logging.log_page) DESC

SQL

Checking query status...