USE enwiki_p;

SELECT user_groups.ug_user as user_id, user.user_name as user_name, user.user_editcount as editcount, true as isCurrent

FROM user_groups

LEFT JOIN user on (user_groups.ug_user = user.user_id)

WHERE user_groups.ug_group = 'bot'

UNION ALL

SELECT user_former_groups.ufg_user as user_id, user.user_name as user_name, user.user_editcount as editcount, false as isCurrent

FROM user_former_groups

LEFT JOIN user on (user_former_groups.ufg_user = user.user_id)

WHERE user_former_groups.ufg_group = 'bot'

ORDER BY editcount DESC;

​