Inactive outreach admins

SQL

USE outreachwiki_p;
SELECT
user_name AS inactive_admin
FROM user_groups
INNER JOIN user
 ON ug_user = user_id
WHERE ug_group = "sysop" #user is outrech admin
AND ug_user NOT IN ( #no logactions in the past 10 months
  SELECT log_user
  FROM logging
  WHERE log_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -12 MONTH), "%Y%m%d%H%i%s")
  AND log_type IN ("block","delete","import","protect","rights", "merge", "massmessage", "abusefilter") #adminactions
)
/* AND user_name NOT IN ( #no edits
  SELECT rev_user_text
  FROM revision
  WHERE rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -12 MONTH), "%Y%m%d%H%i%s")
)
*/
LIMIT 400;
SQL

Checking query status...
