PEP - Quarry

SQL

use enwikinews_p;
SELECT a.*, ru.rev_id, ru.rev_timestamp, lu.log_id, lu.log_timestamp, GROUP_CONCAT(ug.ug_group) 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_group IN ('reviewer', 'sysop', 'bureaucrat')
GROUP BY a.actor_id
SQL

Checking query status...
