Editors by last edit and log action

SQL

SELECT user_name, MAX(rev), MAX(log)
FROM (SELECT user_name, MAX(revision.rev_timestamp) as rev, null as log
FROM actor
INNER JOIN user ON user.user_id = actor.actor_user
INNER JOIN user_groups ON user_groups.ug_user = user.user_id
LEFT JOIN revision ON actor.actor_id = revision.rev_actor
WHERE user_groups.ug_group = 'editor' AND user_name='FoBe'
GROUP BY user_name
UNION
SELECT user_name, null as rev, MAX(logging.log_timestamp) as log
FROM actor
INNER JOIN user ON user.user_id = actor.actor_user
INNER JOIN user_groups ON user_groups.ug_user = user.user_id
LEFT JOIN logging ON logging.log_actor = actor.actor_id
WHERE user_groups.ug_group = 'editor' AND user_name='FoBe'
GROUP BY user_name)
GROUP BY user_name
#ORDER BY MAX(revision.rev_timestamp) ASC
SQL

Checking query status...
