zhwiki: user_groups with last edit/log/right

SQL

USE zhwiki_p;
SELECT ug_user, user_name, groups
	, (SELECT MAX(rev_timestamp) FROM revision WHERE rev_actor = actor_id ORDER BY rev_id DESC LIMIT 1) AS `lastedit`
	, (SELECT MAX(log_timestamp) FROM logging WHERE log_actor = actor_id ORDER BY log_id DESC LIMIT 1) AS `lastlog`
	, (SELECT MAX(log_timestamp) FROM logging WHERE log_type = 'rights' AND log_action = 'rights'
    	AND log_title = REPLACE(user_name, " ", "_") ORDER BY log_id DESC LIMIT 1) AS `lastright`
FROM (
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ', ') AS `groups`
FROM user_groups
LEFT JOIN user ON ug_user = user_id
LEFT JOIN actor ON user_id = actor_user
WHERE ug_group NOT IN ('bot', 'bureaucrat', 'flow-bot', 'interface-admin', 'oversight', 'sysop')
GROUP BY ug_user
LIMIT 10
) temp
SQL

Checking query status...
