enwiki pages transcluding {{soft redirect}} and linking to Special:

SQL

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;
SQL

Checking query status...
