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/10
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
)
GROUP BY rev_user;

SQL

Checking query status...