Edit counts of extendedconfirmed users registered in 2023

SQL

SELECT
	actor_name,
    count(*) as live_edits,
    count(nullif(page_namespace=0,0)) as mainspace,
    count(nullif(page_namespace not in (2,118),0)) as non_user_draft,
    count(nullif(page_namespace not in (2,3,118,119),0)) as non_user_draft_or_talks
FROM
	revision_userindex
    JOIN page ON(rev_page=page_id)
    JOIN actor_revision ON (rev_actor=actor_id)
WHERE
	rev_actor IN (
      SELECT
      	actor_id
  	  FROM
      	user
      	JOIN user_groups ON(user_id=ug_user AND ug_group='extendedconfirmed' AND ug_expiry IS null)
      	JOIN actor_user ON(actor_user=user_id)
      WHERE
      	user_id BETWEEN 45098213 AND 47132573
    )
GROUP BY actor_name;

SQL

Checking query status...