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 * FROM (
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
) AS t1
UNION ALL
SELECT * FROM (
SELECT ug_user AS userid, GROUP_CONCAT(ug_group SEPARATOR "\n") 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
) AS t2
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...