Editors of Abidjan article in Italian Wikipedia

SQL

SELECT DISTINCT a.actor_name AS author, p.page_title AS page
	
FROM 	
	# get edits by users
	frwiki_p.revision_userindex r 

	# get get edits by users
	LEFT JOIN frwiki_p.page p
		ON r.rev_page = p.page_id  
	
    # get user details from actor table
    LEFT JOIN frwiki_p.actor a
    	on r.rev_actor = a.actor_id
	
WHERE 
	# Filtering according to xdate, needs to be adjusted
	r.rev_timestamp > (now() - INTERVAL 10 DAY + 0) # Last 10 days 
	
    # Filter by page title
    #AND p.page_title = 'Wikipédia:Le Bistro'
    

ORDER BY author DESC
LIMIT 10
;

SQL

Checking query status...