Untitled query #36357

SQL

SELECT
	au.actor_name,
    au.actor_id,
    ri.ri_timestamp AS 'last edit',
    li.li_timestamp AS 'last log',
    GREATEST(ri.ri_timestamp, li.li_timestamp) AS last_any,
    (SELECT GROUP_CONCAT(ug2.ug_group) FROM user_groups ug2 WHERE ug2.ug_user = au.actor_user) AS 'groups'
FROM actor_user au
LEFT JOIN user_groups ug
ON au.actor_user = ug.ug_user
LEFT JOIN (
  SELECT
  	ru.rev_actor AS 'ri_actor',
  	MAX(ru.rev_timestamp) AS 'ri_timestamp'
  FROM revision_userindex ru
  GROUP BY ru.rev_actor
) ri ON ri.ri_actor = au.actor_id
LEFT JOIN (
  SELECT
  	lu.log_actor AS 'li_actor',
  	MAX(lu.log_timestamp) AS 'li_timestamp'
  FROM logging_userindex lu
  GROUP BY lu.log_actor
) li ON li.li_actor = au.actor_id
WHERE ug.ug_group = 'sysop'
GROUP BY au.actor_name
ORDER BY last_any ASC
SQL

Checking query status...
