User search - Quarry

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

SQL

SELECT
    user.user_registration,
    user.user_name,
    user.user_editcount,
    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 ON revision.rev_actor = actor.actor_id
    JOIN page ON page.page_id = revision.rev_page
WHERE AND user.user_registration > 20220000000000
    AND user.user_name regexp "^Coop[0-9]{3,}$")
#	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 user.user_id, page.page_title
ORDER BY num_edits DESC
LIMIT 100;

SQL

Checking query status...