Editors of Abidjan article in Italian Wikipedia

SQL

SELECT DISTINCT a.actor_name AS author, 
	(select count(*) from metawiki_p.revision_userindex
     where metawiki_p.revision_userindex.rev_actor = a.actor_id 
     and metawiki_p.revision_userindex.rev_timestamp > (now() - INTERVAL 15 DAY + 0) # total edits from last 15 days
    ) as total, 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 id
 	p.page_id = 11113472
    
#LIMIT 10;
SQL

Checking query status...
