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

SQL

use rowiki_p;
SELECT fi.id, fi.name, fi.edits, fi.admin+se.admin AS admin, fi.bot+se.bot 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
LEFT JOIN (
	SELECT user.user_id AS id, '_' AS name, '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
ORDER BY edits DESC, id
SQL

Checking query status...
