Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Edgars2007
.
Toggle Highlighting
SQL
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; */
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
.
Checking query status...