with B as 

(select user_id, user_name, user_registration, user_editcount

    from user join(select user_id, user_editcount

    from user join user_groups on user.user_id = user_groups.ug_user

    where user_groups.ug_group = 'bot'

    group by user_id)

​

 select user_id, user_name, user_registration, user_editcount

    from user join user_groups on user.user_id = user_groups.ug_user

    where B.user_id is null;