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;DESCRIBE categorylinks;/* SELECT pages.page_title, ids1.pp_value, CONCAT("Kategorie:",cl_title) #'P910', ids2.pp_value, '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 (SELECT * FROM wikidatawiki_p.page WHERE page_namespace = 0) AS items ON 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 cat ON cat.page_title = cl_to JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS ids2 ON ids2.pp_page = cat.page_id WHERE withmain.pl_from IS NULL LIMIT 100;*/
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...