Workshop with GLAM partner (APSID-CI) on november 24, 2017

SQL

SELECT r.rev_user_text AS User, p.page_title AS Page, 
	rev_comment As Summary, 
    DATE_FORMAT(r.rev_timestamp, "%d-%M @ %h:%i") 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 24th November edit-athon
        (r.rev_timestamp BETWEEN 20171124000000 AND 2017112423590000) 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...
