Untitled query #84087

SQL

/*
WITH user_edits AS (
    SELECT
        a.actor_user AS user_id,
        COUNT(*) AS total_edits,
        SUM(CASE WHEN r.rev_timestamp BETWEEN '20220906000000' AND '20240701000000' THEN 1 ELSE 0 END) AS recent_edits
    FROM
        revision r
    JOIN
        actor a ON r.rev_actor = a.actor_id
    WHERE
        r.rev_timestamp < '20240701000000'
    GROUP BY
        a.actor_user
)
SELECT
    user_id
FROM
    user_edits
WHERE
    total_edits > 300
    AND recent_edits >= 20;
*/

  SELECT
        a.actor_user AS user_id,
        COUNT(*) AS total_edits,
        SUM(CASE WHEN r.rev_timestamp BETWEEN '20220906000000' AND '20240701000000' THEN 1 ELSE 0 END) AS recent_edits
    FROM
        revision r
    JOIN
        actor a ON r.rev_actor = a.actor_id
    WHERE
        r.rev_timestamp < '20240701000000'
    GROUP BY
        a.actor_user
    limit 10;
SQL

Checking query status...
