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
SR5
.
Toggle Highlighting
SQL
USE kowiki_p; SELECT pages.page_title, pp_value, "P17", CONCAT( '"', SUBSTRING_INDEX( REPLACE( REPLACE( el_to, "문화재_정보", "" ), "문화재_정보", "" ), "/", 1 ), '"' ) AS id, "S143", "Q328" FROM page JOIN templatelinks ON tl_from = page_id AND tl_title LIKE '문화재_정보%' WHERE wd.page_id NOT IN ( SELECT pl_from FROM wikidatawiki_p.pagelinks WHERE pl_namespace = 120 AND pl_title = "P17" AND pl_from_namespace = wd.page_namespace ) #AND pages.page_title NOT LIKE "%album%" #AND pages.page_title NOT LIKE "%song%" #AND pages.page_title NOT LIKE "%discography%" #AND pages.page_title NOT LIKE "List%" # pl_title IN ("Q11424", "Q15416", "Q24862", "Q202866", "Q5398426") GROUP BY pages.page_title HAVING COUNT(DISTINCT id) = 1;
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...