Editors of Abidjan article in Italian Wikipedia

SQL

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

	# get get edits by users
	LEFT JOIN metawiki_p.page p
		ON r.rev_page = p.page_id  
	
    # get user details from actor table
    LEFT JOIN metawiki_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 = REPLACE("Universal Code of Conduct/Draft review", " ", "_")
    
LIMIT 10;

SQL

Checking query status...