All registered bots on enwiki

Fork of Former registered bots on enwiki by Suriname0

This query is marked as a draft This query has been published by Suriname0.

SQL

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;

SQL

Checking query status...