Untitled query #88789

SQL

SELECT user_name, user_editcount, user_registration, rev_timestamp AS 'Last edit'
FROM `user`
JOIN actor
    ON actor_user = user_id
JOIN revision_userindex
    ON rev_id = (SELECT rev_id FROM revision_userindex
                 WHERE actor_id = rev_actor
                 ORDER BY rev_timestamp DESC
                 LIMIT 1)
WHERE user_name IN ('snoopy', '1997kB', '20041027 tatsu', '511KeV', '94rain', 'A09', 'ABorba (WMF)', 'Ah3kal', 'Alison', 'Ameisenigel', 'AramilFeraxa', 'Atcovi', 'Avicennasis', 'Az1568', 'Baiji', 'Beetstra', 'Bencemac', 'Bencmq', 'Billinghurst', 'Biplab Anand', 'Brewster239', 'Bridget', 'Camouflaged Mirage', 'Church of emacs', 'Civvì', 'Count Count', 'Courcelles', 'CptViraj', 'Cyberpower678', 'DARIO SEVERI', 'Daniuu', 'DannyS712', 'DejaVu', 'Deu', 'Drummingman', 'Eihel', 'Esteban16', 'Ezarate', 'Fabexplosive', 'Fehufanga', 'Ferien', 'FlyingAce', 'Hamish', 'Hazard-SJ', 'Hide on Rosé', 'Holder', 'Hydriz', 'Iluvatar', 'Infinite0694', 'J ansari', 'Jafeluv', 'Jamesofur', 'Jan Myšák', 'Janbery', 'Jasper Deng', 'JavaHurricane', 'Jeff G.', 'Jianhui67', 'Juliancolton', 'K6ka', 'Kanjy', 'Kirito', 'Koavf', 'KonstantinaG07', 'Krinkle', 'LR0725', 'Leonidlednev', 'Leyo', 'LlamaAl', 'Lofty abyss', 'M7', 'MF-Warburg', 'MathXplore', 'Maximillion Pegasus', 'Mazbel', 'MdsShakil', 'Mercy', 'Minorax', 'Mirinano', 'MrJaroslavik', 'Mtarch11', 'Nadzik', 'Neriah', 'NuclearWarfare', 'Paloi Sciurala', 'PlyrStar93', 'Praxidicae', 'QueerEcofeminist', 'Quinlan83', 'RAdimer-WMF', 'Randykitty', 'Renvoy', 'Revi C.', 'Rschen7754', 'Rzuwig', 'SCP-2000', 'SHB2000', 'Sakura emad', 'Samuele2002', 'Saroj', 'Savh', 'Seewolf', 'ShifaYT', 'Streetdeck', 'Stïnger', 'Svartava', 'Synoman Barris', 'Syum90', 'Syunsyunminmin', 'Tanbiruzzaman', 'Teles', 'TenWhile6', 'Ternera', 'Tigerzeng', 'Tropicalkitty', 'Ts12rAc', 'Turkmen', 'Uncitoyen', 'Vogone', 'Waihorace', 'WhitePhosphorus', 'WikiBayer', 'Wutsje', 'XXBlackburnXx', 'Xqt', 'Ymblanter', 'Zabe', 'Zetud', '~riley', 'מקף')
 AND rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 720 DAY),'%Y%m%d%H%i%S'))
ORDER BY rev_timestamp;
SQL

Checking query status...
