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

Fork of Editors from Grants:Modjou/Edit-a-thons Wiktionnaire by Modjou

This query is marked as a draft This query has been published by Modjou.

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 May to June 2018
	(r.rev_timestamp BETWEEN 20190401000000 AND 20190431235959) 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;

SQL

Checking query status...