use tewiki_p;

select

    t.rev_user_text,

    t.cnt

from (

    select

        r.rev_user,

        r.rev_user_text,

        count(*) cnt

    from revision r

    inner join page p

        on r.rev_page = p.page_id

    where

        p.page_namespace = 0

        and r.rev_timestamp >= "20060101000000"

        and r.rev_timestamp < "2020180101000000"

    group by

        r.rev_user,

        r.rev_user_text

    order by cnt desc

    limit 100

) t

inner join user_groups ug

    on ug.ug_user = t.rev_user

where ug.ug_group = 'bot'

order by t.cnt desc

limit 10