Untitled query #85653

SQL

SELECT actor_name,
       (SELECT COUNT(*) FROM revision_userindex WHERE rev_actor = actor_id AND rev_timestamp < 20240902000000) AS sum_yc,
       (SELECT COUNT(*) FROM revision_userindex WHERE rev_actor = actor_id AND rev_timestamp <= 20240908235959) AS sum_tc
FROM actor
WHERE 
#(SELECT COUNT(*) FROM revision_userindex WHERE rev_actor = actor_id AND rev_timestamp < 20240210040227) < 500
#AND (SELECT COUNT(*) 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)
and actor_name in ("أيمن 1974");

#select * from actor where actor_name like "أيمن_1974";
SQL

Checking query status...
