New Page Reviewer activity since November 2016 (excl. admins)

Fork of Reviewer activity since November 2016 by Insertcleverphrasehere

This query is marked as a draft This query has been published by SoWhy.

SQL

SELECT DISTINCT log.log_user_text AS `reviewer`, COUNT(DISTINCT(log.log_page)) AS `reviews`
FROM logging AS 'log'
LEFT JOIN user AS users ON (log.log_user_text = users.user_name)
JOIN user_groups AS ugroups ON (users.user_id = ugroups.ug_user)
  WHERE log_timestamp BETWEEN 20161100000000 AND NOW()
  AND 
  (
    (log_type = 'patrol' AND log_action = 'patrol')
    OR
    (log_type = 'pagetriage-curation' AND log_action = 'reviewed')
  )
  AND ugroups.ug_group NOT RLIKE "sysop"
GROUP BY reviewer
ORDER BY reviews ASC;

SQL

Checking query status...