Untitled query #70862

SQL

SELECT actor_name,
       (SELECT SUM("yc") FROM 
         (
         	SELECT COUNT(rev_id) as "yc" FROM revision WHERE rev_actor = actor_id AND rev_timestamp < DATE_SUB(NOW(), INTERVAL 1 DAY)
           	UNION ALL
           	SELECT COUNT(ar_id) as "yc" FROM archive WHERE ar_actor = actor_id AND ar_timestamp < DATE_SUB(NOW(), INTERVAL 1 DAY)
         )
       ) as "sum_yc",
       (SELECT SUM("tc") FROM 
         (
           SELECT COUNT(rev_id) as "tc" FROM revision WHERE rev_actor = actor_id
           UNION ALL
           SELECT COUNT(ar_id) "tc" FROM archive WHERE ar_actor = actor_id
         )
       ) as "sum_tc"
FROM actor
WHERE actor_name  in (select REPLACE(pl_title, '_', ' ') from pagelinks where
SQL

Checking query status...
