USE enwiki_p;

​

SELECT user_name FROM user

LEFT JOIN user_groups ON ug_user = user_id

-- LEFT JOIN actor ON actor_user = user_id

-- LEFT JOIN revision ON rev_actor = actor_id

WHERE

  ug_group = 'bot'

-- GROUP BY user_id

-- LIMIT 100