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/3
20383869, 20436973, 20441404, 20452276, 20472590, 20513590, 20568271, 20587321,
20623822, 20732776, 20743205, 20761916, 20883229, 20935996, 20957809, 20968443,
21003237, 21035594, 21295589, 21319995, 21339858, 21417351, 21491290, 21540153,
21623111, 21640150, 21685244, 21738558, 21840846, 21886425, 22096151, 22150306,
22197028, 22270931, 22434203, 22531711, 22582001, 22604547, 22665218, 22945049,
23005869, 23039188, 23068335, 23085006, 23175107, 23215288, 23257138, 23299921,
23371081, 23405971, 23498277, 23500032, 23616447, 23671613, 23748255, 23763220,
23770065, 24080262, 24257907, 24271879, 24300964, 24347243, 24566073, 24619723,
24639750, 24796666, 24812038, 24812962, 24884903, 25052795, 25124517, 25153857,
25154634, 25361039, 25420061, 25436602, 25523690, 25530780, 25612507, 25613592,
25762026, 25769944, 25891429, 25977910, 25998241, 26034386, 26110696, 26129968,
26252026, 26386571, 26501846, 26677019, 26766008, 26778615, 26780745, 26830382,
26840736, 26932540, 26951022, 26960688, 26990635, 27081040, 27216374, 27326990,
27354620, 27360059, 27384487, 27470640, 27481655, 27498385, 27538975, 27598246,
27612457, 27681337, 27682281, 27708403, 27814389, 27871940, 27908023, 28030679,
28032930, 28040267, 28045466, 28220603, 28254810, 28276913, 28378926, 28380834,
28407017, 28450565, 28468580, 28546425, 28605863, 28634655, 28644231, 28676898,
28808090, 28922993, 28927018, 29058411, 29111323, 29124390, 29154965, 29222739,
29267997, 29274501, 29274529, 29491253, 29519165, 29523731, 29580982, 29858946
)
GROUP BY rev_user;
SQL

Checking query status...
