PEP - Quarry

SQL

use enwikinews_p;
SELECT a.actor_name,
	#ru.rev_id,
    ru.rev_timestamp AS 'last edit',
    #lu.log_id,
    lu.log_timestamp AS 'last log action',
    GROUP_CONCAT(ug.ug_group) AS 'groups'
FROM actor a
JOIN revision_userindex ru
	ON ru.rev_id = (
      SELECT ru2.rev_id FROM revision_userindex ru2
      WHERE a.actor_id = ru2.rev_actor
      ORDER BY ru2.rev_timestamp DESC
      LIMIT 1
    )
JOIN logging_userindex lu
	ON lu.log_id = (
      SELECT lu2.log_id FROM logging_userindex lu2
      WHERE a.actor_id = lu2.log_actor
      ORDER BY lu2.log_timestamp DESC
      LIMIT 1
    )
JOIN user_groups ug
	ON ug.ug_user = a.actor_user
WHERE ug.ug_group IN ('editor', 'sysop', 'bureaucrat')
GROUP BY a.actor_name
SQL

Checking query status...
