Uploading session during Wiki Loves Africa 2017 in Côte d'Ivoire

SQL

SELECT r.rev_user_text AS User, 
	CONCAT('https://fr.wikipedia.org/wiki/', p.page_title) AS Article

FROM 
	# get  pages wikipedia edited by users
    frwiki_p.revision_userindex r 
    INNER JOIN frwiki_p.page p
    	ON r.rev_page = p.page_id
    
    WHERE 
    	# Filtering according to the 11th November edit-athon
        (r.rev_timestamp BETWEEN 2017112300000 AND 201711240000000) AND 
    	
        r.rev_user_text in ("Nadegekouassi", 
                            "kouadiosamuel12345", 
                            "ehuialfred",
                            "Karellekonan",
                            "Pierrekonan",
                            "Jacobndjan",
                            "Kahoutoure",
                            "abdolvito",
                            "Assbuc.2017",
                            "clemence76"
                            
                           ) 
        
    ORDER BY User DESC;
SQL

Checking query status...
