Latvijas ciemi

This query is marked as a draft This query has been published by Edgars2007.

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;

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

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...