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

SQL

use commonswiki_p;
SELECT editcount, year, count(*)
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
  #WHERE 
  #  rev_timestamp LIKE "2016%" 
#group by floor(log10(user_editcount))
#order by floor(log10(user_editcount))

SQL

Checking query status...