Untitled query #84133

SQL

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

Checking query status...
