Nombre de modifications dans un scope par mois

SQL

set @project = 'Les_sans_pagEs';
set @cat_pdd = concat("Article_du_projet_", @project, "_d'importance_");

select count(*)
from revision, page
where rev_page = page_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")
     )
    ))
SQL

Checking query status...
