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 ', ') AS `groups` FROM user_group WHERE ug_user = user_id GROUP BY ug_user)
	, (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
WHERE user_name = 'Kanashimi'
LEFT JOIN actor ON user_id = actor_user

SQL

Checking query status...