#1Lib1Ref in Bouaké, April 2019

SQL

SELECT r.rev_user_text AS Contributeur, 
	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  
	
WHERE 
    	# Filtering according to the 24th November edit-athon
        (r.rev_timestamp BETWEEN 20190426000100 AND 20190430235959) AND 
        r.rev_user_text in ("Djebitrahie", 
                            "Gilles.ipou", 
                            "Juliegbegre",
                            "Kouamireille1",
                            "Traorejci",
                            "Nguessandavid1973",
                            "Geoduvalier",
                            "Emolokouame",
                            "Dougarmel",
                            "Yaoangekrytel",
                            "Nguessanndri",
                            "Yaojulesyao120",
                            "Hervelino64",
                            "Lossevahi",
                            "Ane edmondk",
                            "Yaohangekrystel"
                           )
GROUP BY Contributeur
ORDER BY Edits DESC;
SQL

Checking query status...
