All groups and former groups of users that were once bots on rowiki

SQL

USE rowiki_p;
-- SHOW TABLES FROM rowiki_p;
-- DESCRIBE rowiki_p.site_stats;
SELECT ug_user, GROUP_CONCAT(ug_group SEPARATOR "\n") AS ug_groups FROM user_groups GROUP BY ug_user;
SELECT ufg_user, GROUP_CONCAT(ufg_group SEPARATOR "\n") AS ufg_groups FROM user_former_groups GROUP BY ufg_user;
(
SELECT ug_user AS userid, GROUP_CONCAT(ug_group SEPARATOR "\n") AS groups, GROUP_CONCAT(ufg_group SEPARATOR "\n") AS formergroups FROM user_groups
LEFT JOIN user_former_groups ON user_groups.ug_user = user_former_groups.ufg_user
GROUP BY userid
)
UNION ALL
(
SELECT ufg_user AS userid, NULL AS groups, GROUP_CONCAT(ufg_group SEPARATOR "\n") AS formergroups FROM user_groups
RIGHT JOIN user_former_groups ON user_groups.ug_user = user_former_groups.ufg_user
WHERE ug_group IS NULL
GROUP BY userid
)
LIMIT 1000
-- HAVING (groups RLIKE "(?m)^autopatrolled$") OR (formergroups RLIKE "(?m)^autopatrolled$")
-- LIMIT 10;
-- SELECT ss_total_edits INTO @testvar FROM rowiki_p.site_stats;
-- SELECT @testvar;
SQL

Checking query status...
