Statistics of editing MediaWiki JS/CSS in ruwiki

SQL

/*USE ruwiki_p;
SELECT
	rev_user_text,
    COUNT(rev_user_text),
    rev_comment, -- если правка одна, видно, что
    page_title, -- и где,
    rev_timestamp -- и когда,
    -- если много - отображается случайная
FROM revision
JOIN page ON page_id = rev_page
WHERE 
    rev_timestamp >= "20170701" AND
    page_namespace = 8 AND
    (page_title LIKE '%.css' OR
    page_title LIKE '%.js')
GROUP BY rev_user_text
ORDER BY COUNT(*) DESC

rewritten by IKhitron
;*/
use ruwiki_p;
select actor_name, count(actor_name) as cou, rev_comment_id, page_title, rev_timestamp 
from actor join
(select * from revision_userindex
 where rev_timestamp > "20170701") rev
join
(select * from page
 where page_namespace = 8
 and (page_title like '%.css' or
      page_title like '%.js')) pg
on rev_actor = actor_id
and page_id = rev_page
group by actor_name
order by cou desc
SQL

Checking query status...
