This query is marked as a draft This query has been published by Samat.

SQL

AخA
 
WITH reg_users AS 
        (SELECT
            user_registration,
            user_editcount,
            user_name    
        FROM
            user
        WHERE
            user_name IN ('Xia', 'Pallor', 'Molnár Gábor Dávid', 'Zerind', 'Jávori István', 'Csicsikálás', 'Malatinszky', 'Hollófernyiges', 'Seba', 'Blua lago', 'VargaA', 'Holes Ádám', 'Csurla', 'Mugli') AND
            user_registration BETWEEN 20030902091147 AND 20221101091147),
        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 > 20221129203950 AND
            rev_timestamp < 20231124203950
            GROUP BY actor_name
        )
        
        SELECT *
        FROM revision
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...