(test) rowiki users by no. of articles created

Testing a version that uses distinct column names, since the usual one suddenly started freaking out.
Also, the results have been wrong since late February 2022 and I'm trying to investigate why.

SQL

USE rowiki_p;
SELECT fi.id AS userid, fi.name AS name, fi.edits AS editcount,
		CASE
			WHEN fi.admin=1 OR se.admin=1 THEN 1
			ELSE 0
		END AS admin,
		CASE
			WHEN (fi.bot=1 AND fi.bot IS NOT NULL) OR se.bot=1 THEN 1
			ELSE 0
		END AS bot
	FROM (
		SELECT user.user_id AS id, user.user_name AS name, user.user_editcount AS edits, ug.admin AS admin, ug.bot AS bot
		FROM user
		LEFT JOIN (
			SELECT ug_user AS id, SUM(admin) AS admin, SUM(bot) AS bot
			FROM (
				SELECT ug_user, ug_group='sysop' AS admin, ug_group='bot' AS bot FROM user_groups
			) AS ab1
			WHERE admin=1 OR bot=1
			GROUP BY ug_user
		) AS ug ON user.user_id=ug.id
		WHERE (user.user_editcount > 600 OR ug.bot=1)
	) AS fi

SQL

Checking query status...