Untitled query #39653

SQL

SELECT
	ug.ug_user,
	a.actor_id,
	a.actor_name,
	rev.rev_timestamp,
    arc.ar_timestamp
FROM user_groups ug
JOIN actor_user a
	ON a.actor_user = ug.ug_user
JOIN revision_userindex rev
	ON rev.rev_id = (
		SELECT rev2.rev_id
		FROM revision_userindex rev2
		WHERE a.actor_id = rev2.rev_actor
		ORDER BY rev2.rev_timestamp DESC
		LIMIT 1
	)
JOIN archive_userindex arc
	ON arc.ar_id = (
		SELECT arc2.ar_id
		FROM archive_userindex arc2
		WHERE a.actor_id = arc2.ar_actor
		ORDER BY arc2.ar_timestamp DESC
		LIMIT 1
    )

WHERE ug.ug_group = 'sysop'
SQL

Checking query status...
