Links from [[Wikipedia:Blocked IPs]]

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

Checking query status...
