Latvijas ciemi

vaicājums1
use lvwiki_p;
select *#pl.pl_title
from pagelinks pl
join page p on p.page_id=pl.pl_from
right join page pv on pv.page_title=pl.pl_title
where pl.pl_title not like "%ciemu_uzskaitījums"#pl.pl_from=248353 and 
	and pl.pl_namespace=0 and pl.pl_from_namespace=0
    and p.page_title like "%ciemu_uzskaitījums"
limit 100;
   # and # and tl.pl_namespace=0 and tl.pl_from_namespace=0#tl.pl_title="%ciemi" and  and p.page_title like "%ciemi"   tl.tl_from_namespace=10 and 


vaicājums2
use lvwiki_p;
select pl_title
from pagelinks pl
#right join page p on p.page_title=pl.pl_title
where pl.pl_from=289369 and pl_title not in (select page_title from page where page_namespace=0)
   # and # and tl.pl_namespace=0 and tl.pl_from_namespace=0#tl.pl_title="%ciemi" and  and p.page_title like "%ciemi"   tl.tl_from_namespace=10 and

SQL

use lvwiki_p;
select *
from templatelinks tl
#join page p on p.page_id=tl.tl_title
where tl.tl_title="Nepilnīga_nodaļa"# and p.page_title like "%ciemi"   tl.tl_from_namespace=10 and 
limit 10;

SQL

Checking query status...