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

SQL

use commonswiki_p;
SELECT editcount, year, count(user_name)
FROM (
  SELECT user_name, floor(log10(user_editcount)) as editcount, YEAR(rev_timestamp) as year
  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, YEAR(rev_timestamp)
)
group by editcount, year
order by editcount, year

SQL

Checking query status...