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 logging.log_actor = actor.actor_id
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...