rowiki users with at least 900 edits + all bots, sorted by edit count

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 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
) AS fi
LEFT JOIN (
	SELECT user.user_id AS id, 0 AS admin, 1 AS bot FROM user
	INNER JOIN (
		SELECT replace(page_title, '_', ' ') AS name
		FROM (SELECT * FROM categorylinks WHERE cl_to='Roboți_Wikipedia') AS catlinks
		INNER JOIN page ON catlinks.cl_from=page.page_id
		WHERE page_namespace=2
	) AS au ON user.user_name=au.name
) AS se ON fi.id=se.id
WHERE fi.edits>590 OR se.bot=1
ORDER BY editcount DESC, userid
limit 1500;
SQL

Checking query status...
