use fawiki_p;

select rev_user, count(rev_id)

from revision

left join user_groups

on rev_user = ug_user

and ug_group = 'Bot'

where ug_group is null

group by rev_user

limit 10