SQL
AخA
use commonswiki_p;
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]]
#WHERE
#rev_timestamp LIKE "2018%"
group by floor(log10(user_editcount))
order by floor(log10(user_editcount))
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.