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 AS userid, GROUP_CONCAT(DISTINCT ug_group SEPARATOR "\n") AS groups, GROUP_CONCAT(DISTINCT 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_user IS NULL
GROUP BY userid
)
ORDER BY userid
HAVING groups RLIKE "(?m)^autopatrolled$"
-- LIMIT 10;
-- SELECT ss_total_edits INTO @testvar FROM rowiki_p.site_stats;
-- SELECT @testvar;

SQL

Checking query status...