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

select * from actor join

(select * from revision_userindex

 limit 10) rev

on rev_actor = actor_id

​