Editors from Grants:Modjou/Wiki Kouman en Côte d'Ivoire 2019

SQL

SELECT r.rev_user_text AS Editors, 
	COUNT(p.page_title) AS Edits,
    COUNT(DISTINCT p.page_title) AS Articles

FROM 	
	# get edits by users
	frwiktionary_p.revision_userindex r 

	# get get edits by users
	LEFT JOIN frwiktionary_p.page p
		ON r.rev_page = p.page_id  

WHERE 
	# Filter by date: to the April 2019 to May 2020
	
    (r.rev_timestamp BETWEEN 20190401000000 AND 20200430235959) 
    AND

	
   r.rev_user_text in ("Modjou","Olivier Yao","Mognissan",
                        "Franckk1","Ruth Axelle","Boidourita", 
                        "Manouka","Doumbia fatou","Kassigilles",
                        "Edmundo Debaulya"
                       )
GROUP BY Editors
ORDER BY Edits DESC;

# Commons uploaders
SELECT i.img_user_text AS Uploaders, 
    COUNT(DISTINCT i.img_name) Images

FROM commonswiki_p.image i
         
WHERE 
	# Filtering according to the 24th November edit-athon
	(i.img_timestamp BETWEEN 20190401000000 AND 20200430235959) AND
	i.img_user_text in ("Modjou","Olivier Yao","Mognissan",
                        "Franckk1","Ruth Axelle","Boidourita", 
                        "Manouka","Doumbia fatou","Kassigilles",
                        "Edmundo Debaulya"
                       )
GROUP BY Uploaders
ORDER BY Images DESC;

# Individual articles edited
SELECT	
    CONCAT("https://fr.wiktionary.org/wiki/", p.page_title) AS Articles,
    r.rev_user_text AS Editors

FROM 	
	# get edits by users
	frwiktionary_p.revision_userindex r

	# get get edits by users
	LEFT JOIN frwiktionary_p.page p
		ON r.rev_page = p.page_id  

WHERE 
	# Filter by date: to the April 2019 to May 2020
	
    (r.rev_timestamp BETWEEN 20190401000000 AND 20200430235959) 
    AND

	r.rev_user_text in ("Modjou","Olivier Yao","Mognissan",
                        "Franckk1","Ruth Axelle","Boidourita", 
                        "Manouka","Doumbia fatou","Kassigilles",
                        "Edmundo Debaulya"
                       )
   
;
SQL

Checking query status...
