Untitled query #13066

SQL

USE lvwiki_p;
select *
from page p
where page_is_redirect=0 and page_namespace=0
	and page_title in ("Anna_no_\"Zaļajiem_jumtiem\"","100._gads_p.m.ē.","Laipa_(mākslas_galerija)","Izlaiduma_cepure")
	and not exists (select * from categorylinks c where p.page_id = c.cl_from AND c.cl_to = "Izolētie_raksti")
    and not exists (select * from pagelinks pl where pl_title=page_title and pl.pl_namespace=0 and pl.pl_from_namespace=0
                   and pl_from not in (select pi.page_id from page pi where pi.page_is_redirect=1)
                    #šeit vēl pielikt, ka tas nav disambigs
                   
                   )
	and not exists (select * from categorylinks c2 where p.page_id = c2.cl_from AND c2.cl_to = "Nozīmju_atdalīšana")
SQL

Checking query status...
