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

SQL

SELECT r.rev_user_text AS User, p.page_title AS Page, rev_comment As Summary, CONVERT(VARCHAR(10), r.rev_timestamp, 112) as Time

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", 
                            "Kouadiosamuel1245", 
                            "Ehuialfred",
                            "Karellekonan",
                            "Pierrekonan",
                            "Jacobndjan",
                            "Kahoutoure",
                            "Abdolvito",
                            "Assbuc.2017",
                            "Clemence76") 
    ORDER BY rev_timestamp ASC;
SQL

Checking query status...
