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 

    page_namespace != 8 AND

    (page_title LIKE '%.css' OR

    page_title LIKE '%.js')

and not rev_comment like "переименовал%"

and not rev_comment like "%быстрое удаление%"

and exists

 (select * from user

  where rev_user_text = user_name

  and exists

  (select * from user_groups

   where user_id = ug_user

   and ug_group = 'sysop'))

GROUP BY rev_user_text

ORDER BY COUNT(*) DESC

;