Active AFC reviewers (1m)

SQL

SELECT user_name as Editor, count(*) as AfCedits
FROM revision_userindex
JOIN actor ON rev_actor = actor_id
JOIN comment_revision ON comment_id = rev_comment_id
JOIN page ON rev_page = page_id
JOIN user ON actor_user = user_id
WHERE
page_title != REPLACE(user_name, ' ', '_') -- underscores
AND page_namespace = 3 -- user talk
AND comment_text RLIKE '(?:accepted|declined|rejected)'
AND rev_timestamp > date_add(now(), interval -30 day)
and user_name in ('2pou', '97198', 'Al83tito', 'Alpha3031', 'AntientNestor', 'Artem.G', 'Asilvering', 'Asparagusus', 'AviationFreak', 'BeanieFan11', 'Bingobro', 'Bkissin', 'BuySomeApples', 'Cabrils', 'Cambalachero', 'Carolina2k22', 'Chidgk1', 'Cl3phact0', 'Clayoquot', 'CodeLyoko', 'Compusolus', 'CurryTime7-24', 'DaxServer', 'Dege31', 'Drat8sub', 'Dudhhr', 'EDG 543', 'Elkman', 'Eternal Shadow', 'Eviolite', 'Fade258', 'FeralOink', 'Festucalex', 'Frostly', 'Fredddie', 'Gobonobo', 'GoingBatty', 'Gorden 2211', 'Grand\'mere Eugene', 'Greenman', 'Gryllida', 'Gusfriend', 'Hellknowz', 'Iffy', 'InterstellarGamer12321', 'JalenFolf', 'Joseph2302', 'Jovanmilic97', 'Justiyaya', 'Ken Tony', 'Lewolka', 'Lightbluerain', 'LittlePuppers', 'LordVoldemort728', 'Marshelec', 'Martin Urbanec', 'Mdaniels5757', 'Newystats', 'Nitesh003', 'Noahfgodard', 'Numberguy6', 'Nyanardsan', 'OceanHok', 'Pbritti', 'PerfectSoundWhatever', 'Philipnelson99', 'Pichemist', 'Praseodymium-141', 'Princess of Ara', 'QuantumRealm', 'Qwerfjkl', 'Reba16', 'Rich Smith', 'RPSkokie', 'S0091', 'Sammi Brie', 'Scorpions13256', 'Seany91', 'SeoR', 'Sionk', 'SounderBruce', 'Spiderone', 'StarryGrandma', 'SWinxy', 'Tagishsimon', 'TartarTorte', 'Thatguy1987', 'TheChunky', 'TipsyElephant', 'Tom (LT)', 'Turnagra', 'Tutwakhamoe', 'Tvx1', 'Unbroken Chain', 'Why? I Ask', 'WildComet', 'WJ94', 'Xclusivzik', 'Zeromonk', 'Zoozaz1', 'Zxcvbnm', 'Israell','Nirmaljoshi', 'Chumpih', 'Felix QW', 'SlySabre', 'Urban Versis 32', 'Ratekreel', 'M4V3R1CK32', 'DecafPotato', 'Casualdejekyll', 'StarryNightSky11', 'Freedom4U', 'Edward-Woodrow', 'Nocturnal781', 'Mrmctorso', 'Oltrepier', 'Anasskoko', 'RoboCric', 'JeffUK', 'Swaggalicious', 'Aplucas0703', 'Ca', 'Apmh', 'Wpscatter', 'Karnataka', 'TechnoSquirrel69', '1TWO3Writer', 'Extorc', 'Khinkali', 'Maliner', 'Capsulecap', 'TheTranarchist','Voorts')
AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group in ('sysop', 'patroller', 'bot')) 
and user_editcount > 1000
group by user_id
having AfCedits > 15
order by AfCedits desc;
SQL

Checking query status...
