Multiple reviews per minute by NPPers (last 2 weeks)

SQL

SELECT user_name as Reviewer, page_title as 'Example page', left(log_timestamp, 12) as Timestamp, count(*) as ReviewsPerMinute
    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
    WHERE log_timestamp > date_add(now(), interval -14 day)
    AND page_is_redirect = 0 -- non-redirects
    and
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
    AND log_namespace = 0 -- Mainspace only
    and user_name != 'DannyS712 bot III'
    and page_id not in (
      select distinct cl_from from categorylinks 
      where
      	cl_to REGEXP '^All_redirects_for_discussion$' 
    	OR cl_to REGEXP '^Articles_for_deletion$'
    ) 
    group by log_actor, Timestamp
    having ReviewsPerMinute > 1
    order by ReviewsPerMinute desc, Timestamp dec
limit 30;
SQL

Checking query status...
