Wiki Challenge Afrique Cote d'Ivoire - Fr.WP

SQL

SET @participants = ("Kahoutoure,Aman ADO,Kod B,Petrus yh,Traorejci,Nicole deba,Élisabeth The lioness Queen,Mouna k,Durand ndri,Tiphabb,Mirevélation,Traorefanta,Douo Tryphene,Grandh2,Mekapeu grace,Charles,Poyet,Djobo Michel,Tchinman,Leader Joël Sebo,Fabrice Yao,Assakan,Iyvan Bazem,Aya,Kkjeanlou,Biko1995");
SET @startDate = ("20220527000001"); # from 27 May, 2022
SET @endDate = ("20220627235959"); # to 27 June, 2022


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;


## 
# DETAILED LIST OF EDITS, ARTICLES EDITED
##

SELECT a.actor_name AS Contributors, 
    CONCAT("http://fr.wikipedia.org/wiki/", REPLACE(p.page_title,' ', '_')) AS Article

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 DESC;
SQL

Checking query status...
