Untitled query #75293

SQL

WITH reg_users AS
        (SELECT
            user_registration,
            user_editcount,
            user_name
        FROM
            user
        WHERE
            user_name IN ('Joalpe', 'Silva Selva', 'Vjcid', 'Taniastronauta', 'Radugako', 'Valentín Or', 'Tbocanegra', 'Jormtz', 'Onica aguilar', 'Tzintia', 'Elias Bego', 'Jer0glific0', 'Occeppa Teteoixnamicqui', 'Kwika Diego', 'VictorMij', 'FidelHM', 'Lezama21', 'Eus SRP') AND
            user_registration BETWEEN '20190717171859' AND '20191015171859'),
        revision AS (
            SELECT
                COUNT(rev_id),
                actor_name
            FROM
                revision
            JOIN actor ON rev_actor = actor_id
            JOIN reg_users ON reg_users.user_name = actor.actor_name
            WHERE
                rev_timestamp > '20191016005605' AND
                rev_timestamp < '20230719000000'
            GROUP BY actor_name
        )
        
        SELECT *
        FROM revision
SQL

Checking query status...
