Editors by last edit and log action

SQL

(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, null as MAX(logging.log_timestamp)
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)
#ORDER BY MAX(revision.rev_timestamp) ASC
SQL

Checking query status...
