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 (

SELECT user_id, user_name

FROM user

WHERE user_name = 'Kanashimi'

) temp

LEFT JOIN actor ON user_id = actor_user

​

​