USE outreachwiki_p;

SELECT

CONCAT("[[User:", user_name, "|", user_name, "]]") AS Username

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 12 months

  SELECT log_user

  FROM logging_compat

  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 in the past 12 months

  SELECT rev_user_text

  FROM revision_compat

  WHERE rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -12 MONTH), "%Y%m%d%H%i%s")

  AND rev_user_text != "DummyAndClause" #dummy and clause to make query working (bug?!)

)

;