SQL
AخA
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.