All of the flagged (and formerly flagged) bots in (en, de, pt, es, zh, ja, fr)wiki

SQL

USE enwiki_p;
SELECT user_name FROM enwiki_p.user_groups INNER JOIN user ON ug_user = user_id WHERE ug_group = "bot"
UNION
SELECT user_name FROM enwiki_p.user_former_groups INNER JOIN user ON ufg_user = user_id WHERE ufg_group = "bot"
UNION
SELECT user_name FROM dewiki_p.user_groups INNER JOIN user ON ug_user = user_id WHERE ug_group = "bot"
UNION
SELECT user_name FROM dewiki_p.user_former_groups INNER JOIN user ON ufg_user = user_id WHERE ufg_group = "bot"
UNION
SELECT user_name FROM ptwiki_p.user_groups INNER JOIN user ON ug_user = user_id WHERE ug_group = "bot"
UNION
SELECT user_name FROM ptwiki_p.user_former_groups INNER JOIN user ON ufg_user = user_id WHERE ufg_group = "bot"
UNION
SELECT user_name FROM eswiki_p.user_groups INNER JOIN user ON ug_user = user_id WHERE ug_group = "bot"
UNION
SELECT user_name FROM eswiki_p.user_former_groups INNER JOIN user ON ufg_user = user_id WHERE ufg_group = "bot"
UNION
SELECT user_name FROM zhwiki_p.user_groups INNER JOIN user ON ug_user = user_id WHERE ug_group = "bot"
UNION
SELECT user_name FROM zhwiki_p.user_former_groups INNER JOIN user ON ufg_user = user_id WHERE ufg_group = "bot"
UNION
SELECT user_name FROM jawiki_p.user_groups INNER JOIN user ON ug_user = user_id WHERE ug_group = "bot"
UNION
SELECT user_name FROM jawiki_p.user_former_groups INNER JOIN user ON ufg_user = user_id WHERE ufg_group = "bot"
UNION
SELECT user_name FROM frwiki_p.user_groups INNER JOIN user ON ug_user = user_id WHERE ug_group = "bot"
UNION
SELECT user_name FROM frwiki_p.user_former_groups INNER JOIN user ON ufg_user = user_id WHERE ufg_group = "bot";
SQL

Checking query status...
