patrollers who do not use page curation

SQL

# patrollers who use twinkle, but not page curation
SELECT DISTINCT CONCAT('*[[Special:Log/',user_name,']]'), user_editcount
FROM `user` 
JOIN `logging` ON user_id = log_user 
JOIN `user_groups` ON user_id = ug_user 
JOIN `page` on log_page = page_id
WHERE ug_group = 'patroller' 
AND page_namespace = 0
AND log_type = 'patrol' 
AND log_params NOT LIKE '%::auto";i:1%' 
AND log_timestamp > (NOW() - INTERVAL 2 YEAR)
AND user_name NOT IN ( #pc users
SELECT DISTINCT user_name FROM `user` 
JOIN `logging` ON user_id = log_user 
JOIN `user_groups` ON log_user = ug_user
JOIN `page` on log_page = page_id
WHERE ug_group = 'patroller' 
AND log_action = 'reviewed'
AND page_namespace = 0  
AND log_timestamp > (NOW() - INTERVAL 2 YEAR));
SQL

Checking query status...
