User search - Quarry

SQL

SELECT
		user_registration,
        user_name,
        page_title,
        COUNT(rev_id) AS num_edits
FROM (
  	SELECT
  		user.user_id,
        user.user_registration,
        user.user_name,
        user.user_editcount,
  		page.page_id,
        page.page_title,
        page.page_namespace,
        revision.rev_id
    FROM user
    JOIN actor ON actor.actor_user = user.user_id
    JOIN revision ON revision.rev_actor = actor.actor_id
    JOIN page ON page.page_id = revision.rev_page
    WHERE user.user_registration > 20220000000000
        AND user.user_name regexp "^Coop[0-9]{3,}$") AS rel_edits,
     (SELECT COUNT(page_id) FROM rel_edits GROUP BY page_id) as page_edits
WHERE true
#	AND num_edits > (SELECT rel_edits_sub.page_id FROM rel_edits AS rel_edits_sub WHERE user_id != rel_edits_sub.user_id)
#	AND rel_edits.page_namespace = 0
GROUP BY rel_edits.user_id, rel_edits.page_title
ORDER BY num_edits DESC
LIMIT 100;
SQL

Checking query status...
