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 page p
where page_is_redirect=0 and page_namespace=0 and page_title="Anna_no_\"Zaļajiem_jumtiem\""
	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 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

330741	0	Dekade		0	0	0	0.26003544306	20160913182431	20160913182439	2582266	464	0	wikitext
330844	0	Jaunpagasta_muiža		0	0	0	0.02677004023	20160915072733	20160914184908	2582672	475	0	wikitext
293206	0	FC_PETROW		0	0	0	0.253490469167	20160226204131	20160226204145	2481628	488	0	wikitext
331292	0	Austrumu_ekspresis_(grāmata)		0	0	0	0.91366361667	20160918170617	20160918140113	2586389	538	0	wikitext
295880	0	Abukiras_līcis		0	0	0	0.828172904508	20160912135412	20160912135414	2557214	549	0	wikitext
3
*/

SQL

Checking query status...