Untitled query #72579

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...
