User search - Quarry

Begin with "raw" set of edits, further filtering and add information to allow filtering based on correlation, filter "correlated"

SQL

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

SQL

Checking query status...