Editors of Grants:Manouka/Notability Checkers workshop 2017

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 xdate, needs to be adjusted
	(r.rev_timestamp BETWEEN 20180100000000 AND 20190630235959) AND
	r.rev_user_text in ("DIDIER WIKI","IVCOM",
						"Pauleric 01","Yasiela","Aristidek5maya",
                        "leunajones","Manouka","African Hope","Papischon",
                        "MODJOU","MOGNISSAN","PAULERIC 01","KCTZCH","KAHOUTOURE",
                        "MALICE 17","lamagniguitoure","Aya.ndja","Affoue Yoboue",
                        "Estelle.dassi","Hoba.elidje","Nadiaeviah","Kodossou bouaffou",
                        "Koffi.noel","Aman Ado","Konan2yao","fofanabdoulaye"
                       ) 
GROUP BY Contributeur
ORDER BY Edits DESC;
SQL

Checking query status...
