Untitled query #39147

SQL

# patrollers who don't use page curation 
SELECT rc_user_text, COUNT(recentchanges.rc_timestamp) AS contributions, MIN(rc_timestamp) as earliest, MAX(rc_timestamp) as latest 
#SELECT patrollers.user_name
FROM (
  SELECT user_name
  FROM user_groups
  JOIN user ON user_id = ug_user
  WHERE ug_group = 'patroller'
) patrollers
LEFT OUTER JOIN ( 
  SELECT log_user_text AS user_name
  FROM logging_userindex
  WHERE log_type IN ('pagetriage-curation', 'patrol')
  AND log_timestamp >= NOW() - INTERVAL 1 YEAR
  AND log_namespace = 0
  GROUP BY log_user_text
) pc 
ON patrollers.user_name = pc.user_name
JOIN recentchanges 
ON rc_user_text = patrollers.user_name
WHERE pc.user_name IS null
GROUP BY rc_user_text;
SQL

Checking query status...
