Pagine con indice ma senza tag pages

Fork of Pagine con indice ma senza tag pages by Candalua

This query is marked as a draft This query has been published by OrbiliusMagister.

SQL

select concat('[[', replace(page_title, '_', ' '), ']]') AS Titolo
from page
join categorylinks on cl_from = page_id and cl_to = 'Pagine_ns0_con_versione_cartacea_a_fronte'
where page_namespace = 0 
and page_is_redirect = 0
and not exists (
  select 1 from templatelinks 
  join linktarget on tl_target_id = lt_id and lt_namespace = 8 and lt_title = 'Proofreadpage_pagenum_template/styles.css'
  where tl_from = page_id 
)
and not exists (
  select 1 from categorylinks where cl_from = page_id and cl_to = 'Testi_trasclusi_da_altri_progetti'
)
and not exists (
  select 1 from categorylinks where cl_from = page_id and cl_to = 'Testi_clonati_da_altri_progetti'
)
order by page_title

SQL

Checking query status...