Editors by last edit and log action

SQL

SELECT user_name, MAX(revision.rev_timestamp), MAX(logging.log_timestamp)
FROM user, user_groups, 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
LEFT JOIN logging ON actor.actor_id = logging.log_actor
WHERE user_groups.ug_group = 'editor' AND user.user_id = actor.actor_user AND user_groups.ug_user = user.user_id AND user_name='FoBe'
GROUP BY user_name
#ORDER BY MAX(revision.rev_timestamp) ASC;

SQL

Checking query status...