Untitled query #70862

SQL

SELECT actor_name,
		# revisions_until_yesterday
       
         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 revisions_until_yesterday,
       # total_edits
       
       	  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 total_edits
FROM actor
	
where actor_name  in (select REPLACE(pl_title, '_', ' ') from pagelinks where  pl_from = 7519882)
limit 10
SQL

Checking query status...
