orphan articles v2 [lvwiki]

USE lvwiki_p;
select *
from pagelinks
where pl_from=page_id  and pl_namespace=0 and pl_from_namespace=0
limit 100

USE lvwiki_p;
select *
from page p
where page_is_redirect=0 and page_namespace=0
	and not exists (select * from categorylinks c where p.page_id = c.cl_from AND c.cl_to = "Izolētie_raksti")
    and p.page_id not in  (select distinct pl.pl_from from pagelinks pl where pl.pl_namespace=0 and pl.pl_from_namespace=0)
	and not exists (select * from categorylinks c2 where p.page_id = c2.cl_from AND c2.cl_to = "Nozīmju_atdalīšana")
/*
Valērijs Burē
InnoDB
*/

SQL

USE lvwiki_p;
select *
from pagelinks
where pl_title='Valērijs_Burē' and pl_namespace=0 and pl_from_namespace=0
limit 100

SQL

Checking query status...