(test) rowiki users by no. of articles created

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
	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 cl_from FROM categorylinks WHERE cl_to='Roboți_Wikipedia'
            ) AS catlinks
			INNER JOIN page ON catlinks.cl_from=page.page_id
			WHERE page_namespace=2
          	UNION
          	SELECT user_name AS name
          	FROM user
          	INNER JOIN (
              	SELECT REPLACE(pl_title, '_', ' ') AS us FROM pagelinks
              	WHERE pl_from = 1995229 AND pl_namespace = 2
            ) AS j ON user.user_name=j.us
		) AS au ON user.user_name=au.name
	) AS se ON fi.id=se.id
	WHERE fi.edits > 600 OR se.bot = 1
SQL

Checking query status...
