WP:NOTWEBHOST - Quarry

SQL

SELECT
    raw.user_registration,
    raw.user_name,
    raw.user_editcount,
    raw.page_namespace,
    raw.namespace_edits,
    SUM(namespace_edits) OVER(PARTITION BY raw.user_name, raw.page_namespace IN (2,3)) AS userspacespace_edits
FROM (
    SELECT
  		user.user_id,
        user.user_registration,
        user.user_name,
        user.user_editcount,
  		page.page_namespace,
  		COUNT(page.page_namespace) AS namespace_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 user.user_registration > 20220000000000
    GROUP BY user.user_id, page.page_namespace
  	LIMIT 10
) as raw
WHERE true
#GROUP BY raw.user_id
LIMIT 100;
SQL

Checking query status...
