Contributors stats Fr.Wikipedia

SQL

SET @participants = ("Abodavid33,Adonis nguessan,Alomonews,Aman ADO,Angeflorekra,Anneprudence,Aristidek5maya,Assalvero,Aya Kouakou,Benoit Soubeyran,Biko05,Cyriac Gbogou,Danny-Franck Komian,Davernepat,Didierwiki,Dorcas2017,Dorianeahozo,Doumass01,Dreykanga,Durand ndri,Emmanuel Dabo,Erico ble,Ferela gnoan,Fra425,FranckAurelien16,Gmpapa,Guelassey,Hassanamir04,Henriette Essoh,Hermann ADJOUMANI,Historyan06,Imane225,Ivcom,JemimaK18,Jiipii225,Jm Gogbeu,Julestoure12,JulianaAya,Kahoutoure,Kassanava3117,Kod B,Kouaben,Kouameroland,Laurettestar14,Makanvi KonÃ©,Marc N'dri,Mientily,Mouna k,Mprincesse750,Nemlin493,Papischou,Pauleric01,Petrus yh,Rodjabosco,Safouu,Samirale12,Samuel Assougba,Sia Guy Marie,Silveretanoh,Soamax,Sultan225,Sylvie laure,Tanoh César 13,Tways2017,YannickSeri54,Yasield,ZiéValy");
SET @startDate = ("20210101000001"); # from 01 Jan, 2021
SET @endDate = ("20211231235959"); # to 31 Dec, 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
	frwiki_p.revision_userindex r 

	# get get edits by users
	LEFT JOIN frwiki_p.page p
		ON r.rev_page = p.page_id 
    
    # get user details from actor table
    LEFT JOIN frwiki_p.actor a
    	on r.rev_actor = a.actor_id
	
	
WHERE 
	# Filter by date range, see variables above
	(r.rev_timestamp BETWEEN @startDate AND @endDate) AND
	FIND_IN_SET (a.actor_name , @participants)
GROUP BY Contributors
ORDER BY Edits DESC;

##### WIKIQUOTE

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, see variables above
	(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...
