List of rowiki articles that were supposedly created more than once based on rev_parent_id

SQL

USE rowiki_p;
SELECT ss_total_edits FROM site_stats;
SELECT SUM(user_editcount) FROM user AS u
WHERE user_editcount <= 650;
SELECT user.user_id AS user_id, user_name, user_editcount,
	CASE
		WHEN (ug.user_admin = 1 OR ue.user_admin = 1) THEN 1
		ELSE 0
	END as user_admin,
	CASE
		WHEN (ug.user_bot = 1 OR ue.user_bot = 1) THEN 1
		ELSE 0
	END as user_bot
FROM user
LEFT JOIN (
	SELECT ug_user, SUM(ug_group="sysop") AS user_admin, SUM(ug_group="bot") AS user_bot FROM user_groups
	GROUP BY ug_user
	HAVING (user_admin = 1 OR user_bot = 1)
) AS ug ON user.user_id = ug.ug_user
LEFT JOIN (
	SELECT user_id, 0 AS user_admin, 1 AS user_bot FROM user
	INNER JOIN (
		SELECT REPLACE(page_title, "_", " ") AS user_name FROM categorylinks
		INNER JOIN page on categorylinks.cl_from = page.page_id
		WHERE (page_namespace = 2 AND cl_to = "Roboți_Wikipedia")
		UNION
		SELECT user_name FROM user
		INNER JOIN pagelinks ON user.user_name = REPLACE(pagelinks.pl_title, "_", " ")
		WHERE (pl_namespace = 2 AND pl_from = 1995229)
	) AS user_exceptions ON user.user_name = user_exceptions.user_name
) AS ue ON user.user_id = ue.user_id
WHERE (user_editcount > 650 OR user.user_bot = 1)
ORDER BY user_editcount DESC, user_id
LIMIT 1500;
SQL

Checking query status...
