Untitled query #53868

SQL

SELECT
  actor_user,
  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
LEFT 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'
  )
  AND*/ actor_name = 'Arellaa'
GROUP BY actor_name
-- HAVING latest < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 6 MONTH),'%Y%m%d%H%i%s')
SQL

Checking query status...
