Untitled query #36357

SQL

SELECT
	au.actor_name,
    au.actor_id,
    (SELECT GROUP_CONCAT(ug2.ug_group) FROM user_groups ug2 WHERE ug2.ug_user = au.actor_user) AS 'groups',
    ri,
    li.*
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
#LEFT JOIN revision_userindex ru
#ON ru.rev_actor = au.actor_id
WHERE ug.ug_group = 'sysop'
GROUP BY au.actor_name
LIMIT 2
SQL

Checking query status...
