SELECT

    actor_name,

    user_editcount,

    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)

    JOIN user ON (actor_user=user_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;