#1Lib1Ref in Bouaké, April 2019

SQL

SELECT r.rev_user_text AS User, p.page_title AS Page
    
    # format timestamp in "D-M h:i" format
    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 20190426000100 AND 20190430235959) AND 
    	
        r.rev_user_text in ("Djebitrahie", 
                            "Gilles.ipou", 
                            "Juliegbegre",
                            "kouamireille1",
                            "traorejci",
                            "nguessandavid1973",
                            "Geoduvalier",
                            "Emolokouame",
                            "dougarmel",
                            "yaoangekrytel",
                            "Nguessanndri",
                            "Yaojulesyao120",
                            "Hervelino64",
                            "Lossevahi",
                            "Ane edmondk",
                            "yaoangekrytel"
                           ) 
    ORDER BY rev_timestamp ASC;
SQL

Checking query status...
