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) as tc FROM archive WHERE ar_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...
