Untitled query #7194

SQL

use lvwiki_p;
select pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
#join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace
join page p on pl.pl_from=p.page_id and p.page_namespace=10 and p.page_is_redirect=0 and pl.pl_namespace=p.page_namespace
where /*pl.pl_from in (select p2.page_id
					from page p2
					where p2.page_title like "%pagasta_ciemi" and p2.page_namespace=10 and p2.page_is_redirect=0)*/
  		#and 
        pl.pl_namespace=0
        and pl.pl_title not in (Select page_title from page where page_namespace=0)

limit 100;

/*
dabūt visas veidnes

select p2.page_id
from page p2
where p2.page_title like "%pagasta_ciemi" and p2.page_namespace=10 and p2.page_is_redirect=0





use lvwiki_p;
select pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
where 
pl.pl_title NOT IN (Select page_title from page where page_namespace=0)
and pl.pl_title IN 
(
select pl_title
from pagelinks pl2
left join page p on pl2.pl_from=p.page_id
where page_namespace=10 and pl_from IN 
  
  (select tl_from
from templatelinks tl2
   join page p2 on tl2.tl_title=p2.page_title and p2.page_namespace=10 and 
where tl2.tl_title like "%pagasta_ciemi" and
tl_from_namespace=10)
  
)

(select p.page_id from pagelinks pl2
						where pl2.pl_from in  and pl.pl_namespace=0)

(select tl.tl_from from templatelinks tl
						where tl.tl_title="Infobox_television_episode" and tl_namespace=10 and tl.tl_from_namespace=0)


	#and pl.pl_title NOT LIKE "%Tour_de_France"
group by pl.pl_title
having COUNT(pl.pl_title)>1
order by COUNT(pl.pl_title) DESC
#limit 850;

*/
SQL

Checking query status...
