SELECT user_name, 

       Count(user_name) 

FROM   user 

       JOIN user_groups 

         ON ug_user = user_id 

       JOIN revision_userindex 

         ON rev_user = user_id 

       JOIN page 

         ON page_id = rev_page 

WHERE  ug_group = "sysop" 

       AND ( ( page_namespace = 2 

               AND Substring_index(page_title, "/", 1) != 

                   REPLACE(rev_user_text, "", "_") 

                 ) 

              OR page_namespace = 8 ) 

       AND page_title RLIKE '^.*\.(css|js)$' 

GROUP  BY user_name 

ORDER  BY Count(user_name) DESC;