Untitled query #70862

SQL

SELECT actor.actor_name,
       SUM(yc_sum.cnt) AS sum_yc,
       SUM(tc_sum.cnt) AS sum_tc
FROM actor
JOIN (SELECT rev_actor, COUNT(rev_id) AS cnt FROM revision WHERE rev_timestamp < 20221201000000 GROUP BY rev_actor) yc_sum
ON yc_sum.rev_actor = actor.actor_id
JOIN (SELECT ar_actor, COUNT(ar_id) AS cnt FROM archive WHERE ar_timestamp < 20221201000000 GROUP BY ar_actor) yc_sum
ON yc_sum.ar_actor = actor.actor_id
JOIN (SELECT rev_actor, COUNT(rev_id) AS cnt FROM revision GROUP BY rev_actor) tc_sum
ON tc_sum.rev_actor = actor.actor_id
JOIN (SELECT ar_actor, COUNT(ar_id) AS cnt FROM archive GROUP BY ar_actor) tc_sum
ON tc_sum.ar_actor = actor.actor_id
WHERE actor_name IN (SELECT REPLACE(pl_title, '_', ' ') FROM pagelinks WHERE  pl_from = 7519882)
GROUP BY actor.actor_name
LIMIT 10;
SQL

Checking query status...
