Untitled query #70862

SQL

SELECT actor_name,
       (SELECT SUM(yc) FROM 
         (
         	SELECT COUNT(rev_id) AS yc FROM revision WHERE rev_actor = actor.actor_id AND rev_timestamp < 20221201000000
           	UNION ALL
           	SELECT COUNT(ar_id) AS yc FROM archive WHERE ar_actor = actor.actor_id AND ar_timestamp < 20221201000000
         )
       ) AS sum_yc,
       (SELECT SUM(tc) FROM 
         (
           SELECT COUNT(rev_id) AS tc FROM revision WHERE rev_actor = actor.actor_id
           UNION ALL
           SELECT COUNT(ar_id) AS tc FROM archive WHERE ar_actor = actor.actor_id
         )
       ) AS sum_tc
FROM actor
WHERE actor_name IN (SELECT REPLACE(pl_title, '_', ' ') FROM pagelinks WHERE  pl_from = 7519882)
LIMIT 10;
SQL

Checking query status...
