Untitled query #7194

SQL

select now();

use wikidatawiki_p;
SELECT concat('{{User:Edgars2007/ID/Template|row|',pl_title,'|',count(*),'}}')
FROM pagelinks
WHERE pl_from_namespace=0 and pl_namespace=120
and pl_title in ("P536","P597","P599","P858","P861","P1146","P1238","P1241","P1285","P1364","P1409","P1447",
                 "P1469","P1541","P1663","P1664","P1825","P1826","P1967","P2020","P2090","P2091","P2162",
                 "P2193","P2195","P2276","P2323","P2327","P2328","P2330","P2331","P2350","P2369","P2398",
                 "P2423","P2446","P2447","P2448","P2449","P2458","P2459","P2481")
GROUP BY pl_title
ORDER BY count(*) DESC;
/*
use enwiki_p;
SELECT enp.page_title, (select cla.cl_to
		from categorylinks cla
		where cla.cl_from=enp.page_id and cla.cl_type="page" and cla.cl_to like "%Winter_Olympics" limit 1)#enel.el_index#enp.page_title, pp_value, enel.el_index
FROM page enp
WHERE enp.page_namespace = 0 and enp.page_title="Andrus_Veerpalu"
and exists (select *
		from categorylinks cla
		where cla.cl_from=enp.page_id and cla.cl_type="page" and LOCATE('Winter_Olympics', cla.cl_to)>0)
		#AND enel.el_from = enp.page_id
limit 50000;


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
left 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 --kods
  		#and 
        pl.pl_namespace=0
        and pl.pl_title not in (Select page_title from page where page_namespace=0)

limit 100;

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)



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...
