/*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

;*/

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

​