campaign 1lib1ref

SQL

WITH reg_users AS 
	(SELECT
      user_registration,
      user_editcount,
      user_name    
    FROM
        user
    WHERE
        user_name IN ('Kateregga1','Kahoutoure','AKibombo','Beatrice Ewa','IngridThomson','Godstime Elijah',
                      'DaSupremo','Ndahiro derrick','Geraldlouw','Henryxcel','Maria zaos','DoreenAppiah','Ptinphusmia',
                      'Ngostary2k','Chiinobis','AfricanLibrarian','Meritkosy','LynnJibril','Tebhogho','Martin Hipangwa',
                      'Olabisi11','Omorodion1','Obuezie','Atibrarian','Pathfinder1953','Aji Ramou','WinnieMKris','Ugwulebo',
                      'Imataa Ephraim','Payc-Reed','Detlef Pfeifer','Aggie Kay','Cindy Chibanga','Lorato Othusitse','Njabulo1',
                      'Maxwell Kasaro','Faith Buyaki','Tuelo Ntlotlang','Olgatime','MvB1Mah','AdjoEsse','Ourytima','Moctar Kamakaté',
                      'Inyor4mr','Alhassan Mohammed Awal','Musahfm','Kyakwera','Olugold','MJayyyy','Sichelesile','Tsodilowee','Sindiept',
                      'Lengeloi','Otama1','Edborteye','Tamdra','Peace Tshuma','Nkatorogo','Nellydieli','Onwuka Glory','Aliyu shaba',
                      'Titus Smiles','M Bash Ne','Samstringz','Beatrice Kaseke','Nwosu Judith C.','Akwugo','Nosakhare Okuons','Aderiqueza',
                      'Odomero2711','Chinakoasogwa','Nsheila','Openworks','Sadammuhammad11234','Accuratecy051','Kingsley Nkem','Tesleemah','Taoheedah',
                      'Timzy D\'Great','Lebron jay','Ibjaja055','Chikeme Chizurum','Atyang344','Iwuala Lucy','Rçag','MEvalyn','InspirePhotos',
                      'Nzechimere','Daberechi16','Nwonwu Uchechukwu P','Korie uchechi Jennifer','Efoby','Senator Choko','Juliegwen','Geraldmamba',
                      'PraiseGideon26','Vekhaguosa1','Shikoha Tautiko','Ishaqyusuf','Palow s coba11','Orielkzn','LilianaLetshabo','Ugoji.john',
                      'Ma0adye','MaskMan','FOULA BAILO GUEYE','Yaseyda','TimaFaSN2022') AND
        YEAR(user_registration) = 2022 AND
   		MONTH(user_registration) = 5),
        
   revision AS (
     SELECT
     COUNT(rev_id),
     	actor_name
     FROM
     	revision
     	JOIN actor ON rev_actor = actor_id
     	JOIN reg_users ON reg_users.user_name = actor.actor_name
     WHERE
     	rev_timestamp > 20220601235959 AND
     	rev_timestamp < 20230101235959
--     YEAR(rev_timestamp) = 2022 AND
--     MONTH(rev_timestamp) > 5 AND
--     MONTH(rev_timestamp) <= 12
     GROUP BY
     	actor_name
   )
     	
        
SELECT *
FROM revision
SQL

Checking query status...
