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
.
use euwiki_p; SELECT #concat('* [[',p.page_title,']]') #concat('* [[:Kategorija:',p.page_title,']]') ll_lang, ll.ll_title, p.page_title from page p join langlinks ll on p.page_id=ll.ll_from where p.page_namespace=0 and p.page_title not like "%/%" and p.page_is_redirect=0 #and ll_lang<>"en" and p.page_id not in (SELECT eu_page_id from wbc_entity_usage wb GROUP BY eu_page_id) and p.page_id in (select cl_from from categorylinks where cl_to="Ko_udalerriak") order by p.page_title asc
Toggle Highlighting
SQL
/*use enwiki_p; SELECT enp.page_title, pp.pp_value, concat('S143')#, cla.cl_to FROM page as enp JOIN wikidatawiki_p.page as wdp on pp.pp_page = enp.page_id and wdp.page_namespace = 0 JOIN page_props as pp on wdp.page_title = pp.pp_value AND pp.pp_propname = 'wikibase_item' JOIN categorylinks as cl on cl.cl_type="page" AND cl.cl_from = enp.page_id LEFT JOIN wikidatawiki_p.pagelinks wdpl on wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P1344' AND wdpl.pl_namespace = 120 #JOIN wikidatawiki_p.pagelinks wdpl2 ON wdpl2.pl_from = wdp.page_id AND wdpl2.pl_title = 'P1447' AND wdpl2.pl_namespace = 120 WHERE enp.page_namespace = 0 AND cl.cl_to like "%Olympics" AND wdpl.pl_from IS NULL #group by enp.page_title #having count(enel.el_index)=1; limit 50; 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 LOCATE('Winter_Olympics', cla.cl_to)>0 limit 1)#enel.el_index#enp.page_title, pp_value, enel.el_index FROM page enp, page_props, wikidatawiki_p.page wdp #LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P1344' AND wdpl.pl_namespace = 120 #JOIN wikidatawiki_p.pagelinks wdpl2 ON wdpl2.pl_from = wdp.page_id AND wdpl2.pl_title = 'P1447' AND wdpl2.pl_namespace = 120 WHERE enp.page_namespace = 0 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 and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id# AND wdpl.pl_from IS NULL AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P1344') AND pp_page = enp.page_id AND pp_propname = 'wikibase_item' AND wdp.page_title = pp_value AND wdp.page_namespace = 0 #group by enp.page_title #having count(enel.el_index)=1 limit 50000; */ 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 LOCATE('Olympics', cla.cl_to)>0 limit 1)#enel.el_index#enp.page_title, pp_value, enel.el_index FROM page enp, page_props#, wikidatawiki_p.page wdp #LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P1344' AND wdpl.pl_namespace = 120 #JOIN wikidatawiki_p.pagelinks wdpl2 ON wdpl2.pl_from = wdp.page_id AND wdpl2.pl_title = 'P1447' AND wdpl2.pl_namespace = 120 WHERE enp.page_namespace = 0 and exists (select * from categorylinks cla where cla.cl_from=enp.page_id and cla.cl_type="page" and LOCATE('Olympics', cla.cl_to)>0) and exists (select * from pagelinks pla where pla.pl_title=pp_value and pla.pl_from=49320232 and pla.pl_namespace=0) #AND enel.el_from = enp.page_id #and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id# AND wdpl.pl_from IS NULL # AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P1344') AND pp_page = enp.page_id AND pp_propname = 'wikibase_item' #AND wdp.page_title = pp_value AND wdp.page_namespace = 0 #group by enp.page_title #having count(enel.el_index)=1 limit 50000;
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...