Multiple reviews per minute by NPPers (last 2 weeks)

SQL

-- SELECT actor_name AS `Reviewer`, logtemp.*, count(*)
--      FROM (
        SELECT user_name, log_actor, left(log_timestamp, 12) as ts, count(*) as c
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
      JOIN actor ON actor_id = log_actor
      JOIN user ON actor_user = user_id
      join user_groups on actor_name=ug_user and ug_group='patroller'
        WHERE log_timestamp > date_add(now(), interval -1 day)
        AND page_is_redirect = 0 and
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND log_namespace = 0
        group by log_actor, ts
        having c>1
--      ) logtemp
      limit 10;
--      HAVING `Article Reviews` >= 100
--     ORDER BY `Article Reviews` DESC;
SQL

Checking query status...
