SELECT

    rev_user,

    DATE_FORMAT(MAX(rev_timestamp), '%Y-%m-%d') AS 'last edit'

FROM revision_userindex

WHERE rev_user IN

(

-- raw data from queries #8689 and #9134, part 3/10

1904640, 1921264, 1925080, 1981037, 1992122, 1997572, 2001020, 2016996, 2088239,

2136008, 2143840, 2157954, 2164108, 2232035, 2273199, 2312902, 2512606, 2639797,

2766075, 2790592, 2877947, 2952402, 2970138, 3045327, 3127387, 3161102, 3381536,

3441262, 3495083, 3516226, 3610436, 3778104, 3835012, 3957791, 3982375, 4007668,

4015543, 4071608, 4175835, 4254336, 4642289, 4738001, 4756805, 4850051, 5019622,

5075885, 5119758, 5197671, 5238361, 5360838, 5379071, 5527268, 5711305, 5879957

)

GROUP BY rev_user;