Editors from Grants:Modjou/Equipment Pocket Wifi

SQL

SELECT r.rev_user_text AS Contributeur, 
	COUNT(p.page_title) AS Edits,
    COUNT(DISTINCT p.page_title) AS Articles,
    COUNT(DISTINCT i.img_name) Images

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  
	
    # get commons images
    LEFT JOIN ( SELECT *
          FROM commonswiki_p.image
          WHERE (img_timestamp BETWEEN 20180100000000 AND 20180630235959) AND
               img_user_text in ("Modjou","African Hope", "Papischou",
                        "Jacquitoz", "kctzch","Ivcom", 
                        "Mr2KM","Modjou","Didierwiki",
                        "Aman ADO","kahoutouré"
                       ) 
               
       ) i
    ON i.img_user_text = r.rev_user_text
	
WHERE 
	img_user_text in ("Modjou","African Hope", "Papischou",
                        "Jacquitoz", "kctzch","Ivcom", 
                        "Mr2KM","Modjou","Didierwiki",
                        "Aman ADO","kahoutouré"
                       ) AND
	# Filtering according to the 24th November edit-athon
	(r.rev_timestamp BETWEEN 20180100000000 AND 20180630235959)

GROUP BY Contributeur
ORDER BY Edits DESC;
SQL

Checking query status...
