User search - Quarry

SQL

SELECT
	correlated.user_registration AS registration,
    correlated.user_name AS username,
    correlated.user_editcount,
    correlated.page_title,
    correlated.num_edits AS page_edits_by_user
FROM (
    SELECT
        raw.user_registration,
        raw.user_name,
        raw.user_editcount,
        raw.page_title,
        raw.num_edits,
        COUNT(raw.page_id) OVER (PARTITION BY raw.page_id) AS num_users_edited_page
    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 LOWER(CONVERT(user.user_name USING 'utf8')) REGEXP "Samet Yücel [0-9]+"
        GROUP BY user.user_id, page.page_id
    ) as raw
    WHERE true
        # Restrict results to specific namespace
#    	AND raw.page_namespace IN (0)
	) AS correlated
WHERE true
	# Filter out pages where no other matched user edited the page
#	AND num_users_edited_page > 1
ORDER BY num_users_edited_page, page_edits_by_user DESC
LIMIT 100;
SQL

Checking query status...
