Users with 200 manual patrols or page curation reviews in 2016

SQL

use enwiki_p;
WITH primaryQuery(log_user,num)
AS (SELECT
log_user, COUNT(DISTINCT log_title) as num
FROM logging
WHERE log_timestamp BETWEEN 20160101000000 AND 20161006000000
AND log_deleted = 0
AND log_namespace = 0
AND ( (
    log_type = 'patrol'
    AND log_params NOT LIKE '%::auto";i:1%'
  ) OR (
    log_type = 'pagetriage-curation'
    AND log_action = 'reviewed'
) )
GROUP BY log_user
HAVING num >= 200
);
SELECT CONCAT("[[Special:Contributions/",user_name,"|",user_name,"]]") AS name, user_editcount AS editcount,
user_registration AS registration, num AS patrolcount
FROM user
WHERE (SELECT COUNT(*) FROM ipblocks WHERE ipb_user = user_id AND ipb_timestamp > '20160101000000') = 0
AND (SELECT COUNT(*) FROM user_groups WHERE ug_user = user_id AND (ug_group = 'sysop' OR ug_group = 'patroller')) = 0
INNER JOIN primaryQuery
ON log_user = user_id
);
SQL

Checking query status...
