Fork of
fawiki users with interface edits
by Huji
This query is marked as a draft
This query has been published
by Yamaha5.
SQL
AخA
use fawiki_p;
select rev_user_text, count(rev_id) interface_edits
from revision
join page
on page_id = rev_page
join user_groups
on rev_user = ug_user
and ug_group = 'sysop'
where page_title like '%.css' or page_title like '%.js'
and page_namespace = 8 -- MediaWiki
group by rev_user_text
order by interface_edits desc
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.