SELECT rc_user_text                  AS editor, 

       Count(rc_id)                  AS recenteditcount, 

       user_editcount, 

       (SELECT Count(ug_group) 

        FROM   user_groups 

        WHERE  ug_user = user_id 

               AND ug_group = "bot") AS isbot 

FROM   recentchanges 

       JOIN user 

         ON user_id = rc_user 

WHERE  rc_type = 0 

GROUP  BY rc_user_text 

ORDER  BY Count(rc_id) DESC

LIMIT 4000;