Test 3 - Quarry

SQL

SELECT
  actor_name,
  STR_TO_DATE(LEFT(MAX(rev_timestamp), 8), '%Y%m%d') AS latest,
  group_concat(distinct ug.ug_group)
FROM revision
JOIN actor
  ON rev_actor = actor_id
  AND actor_user <> 0
JOIN user_groups AS ug
  ON ug_user = actor_user
LEFT JOIN user_groups AS ug2
  ON ug2.ug_user = actor_user
  AND ug2.ug_group = 'bot'
WHERE
  ug2.ug_group IS NULL
  AND ug.ug_group IN (
    'rollbacker',
    'patroller',
    'eliminator',
    'sysop',
    'bureaucrat',
    'Image-reviewer',
    'templateeditor',
    'oversight'
  )
GROUP BY actor_name
HAVING latest < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 6 MONTH),'%Y%m%d%H%i%s')
SQL

Checking query status...
