USE trwiki_p;

SELECT zirt.user_name as k, datediff(NOW(),zirt.zaman) as fark

FROM (SELECT *, now() as zaman

      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

     LEFT JOIN ipblocks

        ON ipb_user =latest.rev_user) as zirt limit 10;

​

​