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 *
from revision, page
where rev_page = page_id
and (page_namespace = 0 or page_namespace = 1)
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")
     )
    ))
limit 5

SQL

Checking query status...