zhwiki: search user last edit/log/right

Fork of zhwiki: user_groups with last edit/log/right by Xiplus

This query is marked as a draft This query has been published by Xiplus.

SQL

USE zhwiki_p;
SELECT user_id, user_name
	, (SELECT GROUP_CONCAT(ug_group SEPARATOR ', ') FROM user_groups WHERE ug_user = user_id GROUP BY ug_user) AS `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 user
LEFT JOIN actor ON user_id = actor_user
WHERE user_name = 'Kanashimi'

SQL

Checking query status...