Contributors stats Fr.Wikipedia

SQL

SET @participants = ("Aristidek5maya,Petrus yh,Audrey Ingrid,Dakfabrice,Nanoque,Mariefrancebanga,Kouakou trika,Affoue.yoboue,Safouu,Akissi.kouakou,Boidourita,Adolphe Yao,Dezkouame,Micaelngb,Aman ADO,Aissata Bah,Babawabewa,PriscilleKouame,Dassi coucou,Mouna k,Durand ndry,Kahoutoure");
SET @startDate = ("20200504000001"); # from 04 May, 2020
SET @endDate = ("20210504235959"); # to 04 May, 2021
SELECT a.actor_name AS Contributors, 
	COUNT(p.page_title) AS Edits,
    COUNT(DISTINCT p.page_title) AS Articles

FROM 	
	# get edits by users
	frwikiquote_p.revision_userindex r 

	# get get edits by users
	LEFT JOIN frwikiquote_p.page p
		ON r.rev_page = p.page_id 
    
    # get user details from actor table
    LEFT JOIN frwikiquote_p.actor a
    	on r.rev_actor = a.actor_id
	
	
WHERE 
	# Filter by date range: from March 5, 2019 to March 05, 2020 
	(r.rev_timestamp BETWEEN @startDate AND @endDate) AND
	FIND_IN_SET (a.actor_name , @participants)
GROUP BY Contributors
ORDER BY Edits DESC;


## LIST OF ARTICLES EDITED/ADDED
SELECT	
    CONCAT("https://fr.wiktiquote.org/wiki/", p.page_title) AS Articles,
    a.actor_name AS Editors

FROM 	
	# get edits by users
	frwikiquote_p.revision_userindex r 

	# get get edits by users
	LEFT JOIN frwikiquote_p.page p
		ON r.rev_page = p.page_id  
    
    # get user details from actor table
    LEFT JOIN frwikiquote_p.actor a
    	on r.rev_actor = a.actor_id

WHERE 
	(r.rev_timestamp BETWEEN @startDate AND @endDate) AND
	FIND_IN_SET (a.actor_name , @participants)
	
    # exclude user pages
    AND NOT FIND_IN_SET (REPLACE(p.page_title, "_", " ")  , @participants)
GROUP BY Articles
;
SQL

Checking query status...
