Untitled query #79697

SQL

WITH reg_users AS 
        (SELECT
            user_registration,
            user_editcount,
            user_name    
        FROM
            user
        WHERE
            user_name IN ('Silva Selva', 'PetrohsW', 'Fagoaga', 'Ninonllano', 'Danfermat2014', 'Clemenflays', 'Clauroinfante', 'Cutzin', 'Ikiwiki1984', 'Edo21c', 'ClaudiaOcA', 'Lizperez.c', 'Vjcid', 'Marisol Frías', 'Taniastronauta', 'Plathando', 'Xochipiltecatl', 'Mromandl', 'Rurudesu', 'Cliografo', 'Torres mejia', 'Diaz campos', 'Radugako', 'Nenenki', 'Valentín Or', 'MonSH', 'Marianacordoban', 'Sarcle', 'Akatoxkatl', 'Tbocanegra', 'Antropfem') AND
            user_registration BETWEEN 20180107183740 AND 20180308183740),
        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 > 20180309005637 AND
            rev_timestamp < 20190304005637
            GROUP BY actor_name
        )
        
        SELECT *
        FROM revision
SQL

Checking query status...
