USE trwiki_p;

SELECT user_name, last_edit, user_editcount, ug_group, ipb_id

    FROM (SELECT *, MAX(rev_timestamp) AS last_edit FROM revision WHERE rev_user > 0 GROUP BY rev_user) AS latest

    JOIN user

        ON user_id = latest.rev_user

     JOIN user_groups

        ON ug_user = latest.rev_user

     JOIN ipblocks

        ON ipb_user = latest.rev_user

WHERE   user_name ='Monsters60'

LIMIT 200;