User search - Quarry

SQL

SELECT
	unfiltered.user_registration AS registered,
	unfiltered.user_name AS username,
	unfiltered.user_editcount AS editcount,
	unfiltered.page_title AS page_title,
	unfiltered.num_edits AS page_edits_by_user
FROM (
  	SELECT
  		user.user_id,
        user.user_registration,
        user.user_name,
        user.user_editcount,
  		page.page_id,
        page.page_title,
        page.page_namespace,
        COUNT(page.page_id) as num_edits
    FROM user
        JOIN actor ON actor.actor_user = user.user_id
        JOIN revision_userindex ON revision_userindex.rev_actor = actor.actor_id
        JOIN page ON page.page_id = revision_userindex.rev_page
    WHERE true
		# Only scan users who registered after date
    	AND user.user_registration > 20220000000000

		# Only scan users who's name matches regex
        AND user.user_name regexp "^Coop[0-9]{3,}$"
  	GROUP BY user.user_id, page.page_id
		) as unfiltered
WHERE true
	# Restrict results to specific namespace
#	AND unfiltered.page_namespace IN (0)

	# Filter out pages that have only been edited by one user
    AND COUNT(unfiltered.page_id) OVER (PARTITION BY unfiltered.page_id) > 1
ORDER BY page_edits_by_user DESC
LIMIT 100;
SQL

Checking query status...
