Editors of Abidjan article in Italian Wikipedia

This query is marked as a draft This query has been published by Samuel (WMF).

SQL

SELECT DISTINCT r.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 
	AND
    # Filter by page title
    p.page_title = 'Wikipédia:Le Bistro'
    

ORDER BY author DESC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...