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  last_edit > DATE_ADD(NOW(), INTERVAL -2 DAY)

AND ipb_id IS not NULL

ORDER BY  user_editcount

LIMIT 200;