enwiki redirects to Special: namespace

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 1/3
79, 4295, 5094, 5705, 7872, 12176, 15143, 26248, 31530, 35752, 38427, 53396,
54890, 59944, 69412, 70142, 82697, 84612, 86163, 90397, 90814, 120801, 135518,
136926, 150564, 153741, 154991, 158840, 161735, 167187, 169932, 191017, 202394,
218166, 221304, 242472, 244713, 246230, 254396, 262675, 270405, 278097, 282582,
288189, 299408, 302457, 306659, 318807, 323105, 334887, 342294, 342538, 346308,
346341, 358166, 377389, 378390, 380571, 383662, 410440, 410898, 417165, 451287,
455421, 459990, 461300, 467815, 469625, 473485, 483374, 491706, 502540, 516856,
547792, 551300, 560483, 563447, 594997, 613068, 618430, 623801, 643450, 678051,
686510, 687767, 776137, 836656, 836780, 878293, 901576, 937895, 964805, 1168880,
1169249, 1179460, 1195998, 1218696, 1276024, 1294969, 1305296, 1306352, 1351252,
1368779, 1455149, 1487243, 1492328, 1588193, 1612789, 1616973, 1646408, 1829761,
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,
6127189, 6169056, 6196463, 6209803, 6262758, 6282205, 6282417, 6524670, 6530726,
6561336, 6965027, 7181920, 7254364, 7264712, 7302427, 7332659, 7447956, 7505908,
7529026, 7614868, 7641765, 7902442, 7948812, 8259432, 8271180, 8356162, 8372814
)
GROUP BY rev_user;
SQL

Checking query status...
