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
Matěj Suchánek
.
Toggle Highlighting
SQL
USE cswiki_p; SELECT pages.page_title, ids1.pp_value, CONCAT("Kategorie:",cl_to), ids2.pp_value, 'P910' , 'S143', 'Q191168' FROM (SELECT * FROM page WHERE page_namespace = 0) AS pages JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS ids1 ON ids1.pp_page = pages.page_id JOIN (SELECT * FROM categorylinks WHERE cl_sortkey_prefix = ' ') AS cl ON cl_from = pages.page_id JOIN wikidatawiki_p.page AS items ON items.page_namespace = 0 AND items.page_title = ids1.pp_value LEFT JOIN (SELECT * FROM wikidatawiki_p.pagelinks WHERE pl_title = 'P910' AND pl_namespace = 120 AND pl_from_namespace = 0) AS withmain ON withmain.pl_from = items.page_id JOIN (SELECT * FROM page WHERE page_namespace = 14) AS categories ON categories.page_title = cl_to JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS ids2 ON ids2.pp_page = categories.page_id WHERE withmain.pl_from IS NULL ORDER BY pages.page_title;
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...