AfDs created by an NPP reviewer or administrator in the past week

SQL

SELECT user_name, COUNT(*) as 'MainspaceEdits1m' FROM revision_userindex JOIN page ON page_id = rev_page
	   JOIN actor_user on rev_actor = actor_id
	   JOIN `user` on actor_user=user_id
       WHERE user_name in ('Damian Yerrick', 'Jimbo Wales', 'The Epopt', 'Dreamyshade', 'Brooke Vibber', 'Mav', 'Bryan Derksen', 'Robert Merkel', 'Zundark', 'Manning Bartlett', 'Mark', 'Ed Poor', 'Lorax', 'Andre Engels', 'Eclecticology', 'XJaM', 'Fubar Obfusco', 'William Avery', 'Roadrunner', 'Ellmist', 'Daniel C. Boyer', 'Nonenmac', 'Mjb', 'Rsabbatini', 'Camembert', 'KF', 'Ewen', 'Atlan', 'Ram-Man', 'Mkmcconn', 'Mrwojo', 'Frecklefoot', 'RTC', 'Kchishol1970', 'Boud', 'Zocky', 'Chris-martin', 'Earth', 'Fred Bauder', 'Voidvector', 'Lexor', 'DopefishJustin', 'Mahjongg', 'Dominus', 'Pnm', 'Kku', 'SGBailey', 'Tannin', 'Dramatic', 'Dcljr', 'Cameron Dewe', 'Seav', 'Yann', 'Karada', 'Skysmith', 'Arpingstone', 'Paul A', 'Pcb21', 'Greenman', 'Ellywa', 'KAMiKAZOW', 'Haakon', 'Stan Shebs', 'Stevenj', 'William M. Connolley', 'Jpatokal', 'Strebe', 'Theresa knott', 'Bueller 007', 'Darkwind', 'Kevin Baas', 'Julesd', 'Pratyeka', 'Jll', 'Glenn', 'Error', 'Stefan-S', 'Rossami', 'Kwekubo', 'Big iron', 'Andres', 'Cimon Avaro', 'Jeandré du Toit', 'Samw', 'Cherkash', 'GCarty', 'Lukobe', 'Lee M', 'Mxn', 'BRG', 'JASpencer', 'Schneelocke', 'Nikola Smolenski', 'Hike395', 'Coren', 'Jengod', 'Mulad', 'Dying', 'Crissov', 'PaulinSaudi', 'David Newton', 'EmphasisMine', 'Boson', 'CTSWyneken', 'Stone', 'Choster', 'Stismail', 'Jitse Niesen', 'Tedius Zanarukando', 'Lou Sander', 'Hydnjo', 'Colipon', 'Greenrd', 'Tb', 'WhisperToMe', 'Zoicon5', 'Polaris999', 'Steinsky', 'Timc', 'Radiojon')
        and rev_timestamp >= date_add(now(), interval -30 day)
         AND page_namespace = 0 -- Mainspace, from [[WP:Namespaces]]
       group by rev_actor
       order by count(*) desc
 --      having count(*) > 300
SQL

Checking query status...
