Wikiquote Edit-athon in Côte d'Ivoire (2020)

SQL

SET @participants = ("Arisidek5maya","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 = "20200530000001" # from May 30, 2020
SET @endDate = "20200901235959" # to September 01, 2020
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 May 30, 2020 to September 01, 2020 
	(r.rev_timestamp BETWEEN @startDate AND @endDate) AND
	FIND_IN_SET (a.actor_name , @participants)
GROUP BY Contributors
ORDER BY Edits DESC;
SQL

Checking query status...
