zhwiki: user_groups with last edit/log/right

SQL

USE zhwiki_p;
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ', ') AS `groups`
	, (SELECT rev_timestamp FROM revision WHERE rev_actor = actor_id ORDER BY rev_id DESC LIMIT 1) AS `lastedit`
	, (SELECT log_timestamp FROM logging WHERE log_actor = actor_id ORDER BY log_id DESC LIMIT 1) AS `lastlog`
	, (SELECT log_timestamp FROM logging WHERE log_title = REPLACE(user_name, " ", "_") ORDER BY log_id DESC LIMIT 1) AS `lastright`
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

SQL

Checking query status...