Untitled query #69129

SQL

set @project = 'Espéranto';
set @cat_pdd = concat("Article_du_projet_", @project, "_d'importance_");

select actor_name, count(*) as nb
from revision, page, actor
where rev_page = page_id
and rev_actor = actor_id
and (page_namespace = 0 or page_namespace = 1)
and rev_timestamp >= 20221001000000 and rev_timestamp < 20221101000000
and page_id in
(select distinct page_id
from page, categorylinks
where page_id = cl_from
and (page_namespace = 0 and cl_to = concat("Portail:", @project, "/Articles liés")
     or page_namespace = 1 and (
       cl_to = concat(@cat_pdd, "maximum") or
       cl_to = concat(@cat_pdd, "élevée") or
       cl_to = concat(@cat_pdd, "moyenne") or
       cl_to = concat(@cat_pdd, "faible") or
       cl_to = concat(@cat_pdd, "inconnue")
     )
    ))
group by (actor_name)
SQL

Checking query status...
