Untitled query #88788

SQL

SELECT user_name, user_registration, rev_timestamp
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 ('1234qwer1234qwer4', '1997kB', 'Abusefilter global search service account', 'Ameisenigel', 'Ankry', 'ChongDae', 'Codename Noreste', 'Count Count', 'CptViraj', 'Daimona Eaytoy', 'Daniuu', 'EggRoll97', 'Fehufanga', 'Hégésippe Cormier', 'Jimmy Xu', 'Jules*', 'LPfi', 'Leaderboard', 'Maximillion Pegasus', 'Mdaniels5757', 'Msz2001', 'MusikAnimal', 'Nemo bis', 'Nullzero', 'Orlodrim', 'Praxidicae', 'ShifaYT', 'Steinsplitter', 'Supertoff', 'Tamzin', 'Titore', 'Vogone', 'WikiBayer', 'Wüstenspringmaus', 'XXBlackburnXx', 'Zzuuzz')
 AND rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 360 DAY),'%Y%m%d%H%i%S'))
ORDER BY rev_timestamp;
SQL

Checking query status...
