patrollers who do not use page curation

SQL

# patrollers who use twinkle, but not page curation
#SELECT DISTINCT user_name FROM `user` 
#JOIN logging ON user_id = log_user 
#JOIN user_groups ON user_id = ug_user 
#WHERE ug_group = 'patroller' 
#AND log_type = 'patrol' 
#AND log_params NOT LIKE '%::auto";i:1%' 
#AND log_timestamp > (NOW() - INTERVAL 1 MONTH);

#AND user_id 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
WHERE ug_group = 'patroller' 
AND log_action = 'reviewed'
AND log_timestamp > (NOW() - INTERVAL 1 MONTH);

SQL

Checking query status...