Editors from Grants:Modjou/Equipment Pocket Wifi

SQL

SELECT r.rev_user_text AS Contributeur, 
	r.rev_comment AS Edits, 
	i.img_name AS Images

FROM 
	# get edits by users
	frwiki_p.revision_userindex r 
	
	# get get edits by users
	INNER JOIN frwiki_p.page p
		ON r.rev_page = p.page_id  
	
	# get commons images
	INNER JOIN commonswiki_p.image i
		ON i.img_user_text = r.rev_user_text
	 
WHERE 
	# Filtering according to the 24th November edit-athon
	(i.img_timestamp BETWEEN 20180101235959 AND 20180630235959) AND 
	r.rev_user_text IN ("Modjou", 
						"African Hope", 
						"Papischou")
GROUP BY Images
ORDER BY Images DESC;

SQL

Checking query status...