Untitled query #85654

SQL

WITH revision_counts AS (
    SELECT 
        rev_actor,
        SUM(CASE WHEN rev_timestamp < 20240210040227 THEN 1 ELSE 0 END) AS sum_yc,
        SUM(CASE WHEN rev_timestamp <= 20240810040227 THEN 1 ELSE 0 END) AS sum_tc
    FROM revision_userindex
    GROUP BY rev_actor
    HAVING sum_yc < 500 AND sum_tc >= 500
),
excluded_actors AS (
    SELECT REPLACE(lt_title, '_', ' ') AS pl_title 
    FROM pagelinks 
    INNER JOIN linktarget ON lt_id = pl_target_id 
    WHERE pl_from = 7519882
)
SELECT 
    a.actor_name, 
    rc.sum_yc, 
    rc.sum_tc
FROM 
    actor a
JOIN 
    revision_counts rc ON a.actor_id = rc.rev_actor
LEFT JOIN 
    excluded_actors ea ON a.actor_name = ea.pl_title
WHERE 
    ea.pl_title IS NULL;
SQL

Checking query status...
