| SELECT user_name, ug_group, MAX(rev_timestamp) AS latest_edit
FROM user
JOIN... |
1 year ago |
| SELECT user_name, ug_group, MAX(rev_timestamp)
FROM user
JOIN user_groups ON... |
1 year ago |
| SELECT user_name, ug_group
FROM user
JOIN user_groups ON user_id =... |
1 year ago |
