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 2/3

8390765, 8500787, 8606792, 8641695, 8681972, 8757051, 9078664, 9080397, 9109237,

9197344, 9218543, 9346035, 9600753, 9633942, 9676078, 9937763, 9945971, 9961776,

10051232, 10152666, 10236113, 10333458, 10341578, 10357594, 10539714, 10603863,

10614794, 10728040, 10806116, 10867422, 10941947, 10951369, 10962546, 11112747,

11184537, 11220631, 11226188, 11508456, 11557355, 11621979, 11656865, 11784204,

11833549, 11902450, 11916782, 11917807, 12023796, 12026264, 12054433, 12202350,

12460163, 12539517, 12553070, 12582288, 12641526, 12711397, 12782318, 13541347,

13588723, 13725251, 13760686, 13821812, 13936758, 13975403, 14386179, 14504098,

14550933, 14596827, 14688020, 14730724, 14860062, 14882394, 14970971, 15088191,

15132776, 15220326, 15263940, 15420856, 15532149, 15685779, 15763484, 15855277,

15881234, 15891802, 15929326, 15991542, 16019814, 16075528, 16085987, 16112210,

16123725, 16163846, 16191043, 16203606, 16342395, 16349307, 16396275, 16578927,

16635116, 16663390, 16733028, 16776597, 16787888, 16796352, 16852310, 16909869,

16944783, 17079922, 17107579, 17128580, 17157159, 17200709, 17223351, 17375300,

17397640, 17443185, 17651076, 17656933, 17675815, 17692156, 17746512, 17772824,

17847210, 17863160, 17911012, 17944471, 18017774, 18177679, 18281217, 18305830,

18336458, 18364158, 18378667, 18474721, 18557890, 18600472, 18622101, 18853599,

18892583, 18924672, 18985077, 19075131, 19177549, 19212093, 19244234, 19261965,

19283784, 19285809, 19500131, 19651326, 19804834, 19818307, 19876315, 19912518,

19928789, 19939090, 19959423, 19965906, 20255624, 20313089, 20319727, 20371397

)

GROUP BY rev_user;

​