Untitled query #85654

SQL

SELECT actor_name,
       (SELECT COUNT(rev_id) FROM revision_userindex WHERE rev_actor = actor_id AND rev_timestamp < 20240210040227) AS sum_yc,
       (SELECT COUNT(rev_id) FROM revision_userindex WHERE rev_actor = actor_id AND rev_timestamp <= 20240810040227) AS sum_tc
FROM actor
WHERE (SELECT COUNT(rev_id) FROM revision_userindex WHERE rev_actor = actor_id AND rev_timestamp < 20240210040227) < 500
AND (SELECT COUNT(rev_id) FROM revision_userindex WHERE rev_actor = actor_id AND rev_timestamp <= 20240810040227) >= 500
and actor_name not in (
  SELECT REPLACE(lt_title, '_', ' ') "pl_title" from pagelinks 
  inner join linktarget ON lt_id = pl_target_id where  pl_from = 7519882);
SQL

Checking query status...
