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

SQL

SET @participants = 'Yasield,Tways2017,Abiba Pauline,Kod_B,Peny99,Petrus yh,Aya.ndja,Koffi.noel,Lamagniguitoure,Aristidek5maya';
SELECT r.rev_user_text 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  
	
	
WHERE 
	# Filter by date range: from March 5, 2019 to March 05, 2020 
	(r.rev_timestamp BETWEEN 20190305000001 AND 20200305235959) AND
	r.rev_user_text in (@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,
    r.rev_user_text 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  

WHERE 
	# Filter by date range: from March 5, 2019 to March 05, 2020 
	(r.rev_timestamp BETWEEN 20190305000001 AND 20200305235959) AND
	r.rev_user_text IN ("Yasield", "Tways2017", "Abiba Pauline", "Kod_B", "Peny99", 
                        "Petrus yh", "Aya.ndja", "Koffi.noel", "Lamagniguitoure", "Aristidek5maya") 
	
    # exclude user pages
    AND REPLACE(p.page_title, "_", " ") NOT IN ("Yasield", "Tways2017", "Abiba Pauline", "Kod_B", "Peny99", 
                        "Petrus yh", "Aya.ndja", "Koffi.noel", "Lamagniguitoure", "Aristidek5maya")
GROUP BY Articles
;
SQL

Checking query status...
