Number of participants in Commons:Photo_challenge grouped by number of edits and year

SQL

use commonswiki_p;
SELECT user_name
#SELECT floor(log10(user_editcount)), count(*)
FROM user 
JOIN revision 
	ON user_id = rev_user 
JOIN page 
	ON rev_page = page_id 
	and page_namespace = 4 # pages in Commons namespace
join templatelinks 
	on page_id = tl_from  
	and tl_namespace = 10  
	AND tl_title="Photo_challenge_rules" # pages transcluding [[template:Photo_challenge_rules]]
group by user_name
#WHERE 
#  rev_timestamp LIKE "2016%" 
#group by floor(log10(user_editcount))
#order by floor(log10(user_editcount))

SQL

Checking query status...