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

SQL

-- SET STATEMENT max_statement_time = 1 FOR
-- SELECT SLEEP(2)
USE rowiki_p;
SELECT rev_id, rev_page, rev_actor, rev_timestamp FROM revision
WHERE rev_actor = 3193 AND rev_parent_id = 0
ORDER BY rev_timestamp DESC
LIMIT 100;

/*USE rowiki_p;
SELECT actor_user AS user_id, actor_name AS user_name, COUNT(1) AS user_articles, MAX(rev_timestamp) AS user_latestcreation FROM (
	SELECT MAX(rev_id) AS rev_id, rev_actor, actor_user, actor_name, MAX(rev_timestamp) AS rev_timestamp FROM revision
	INNER JOIN page ON revision.rev_page = page.page_id
	/*LEFT JOIN (
		SELECT pp_page, pp_propname FROM page_props
		WHERE pp_propname = "disambiguation"
	) AS pp ON revision.rev_page = pp.pp_page*//*
	LEFT JOIN actor ON revision.rev_actor = actor.actor_id
	WHERE (rev_parent_id = 0 AND page_namespace = 0 AND page_is_redirect = 0 /*AND pp_propname IS NULL*//*)
	GROUP BY rev_page
) AS utilizatori
GROUP BY user_id
HAVING user_articles >= 10
ORDER BY user_articles DESC
LIMIT 2000;*/

SQL

Checking query status...