TEST 1 - Quarry

SQL

USE kowiki_p;
SELECT ko.page_title, pp_value, "P838",
CONCAT( '"', REPLACE( REPLACE( el_to, "문화재_정보", "" ), "/", "" ), '"' ) AS id, "S143", "Q191168"
FROM (SELECT * FROM externallinks WHERE el_to LIKE "번호_=%") AS el# AND el_to RLIKE "/id[0-9]+/?$") AS el
JOIN (SELECT * FROM page WHERE page_namespace = 0 AND page_title NOT LIKE "Seznam%") AS ko ON ko.page_id = el_from
JOIN (SELECT * FROM page_props WHERE pp_propname = "wikibase_item") AS props ON pp_page = ko.page_id
JOIN (SELECT * FROM wikidatawiki_p.page WHERE page_namespace = 0) AS wd ON wd.page_title = pp_value
WHERE wd.page_id NOT IN (
  SELECT pl_from FROM wikidatawiki_p.pagelinks WHERE pl_namespace = 120 AND pl_title = "P838" AND pl_from_namespace = wd.page_namespace
) AND wd.page_id IN (
  SELECT pl_from FROM wikidatawiki_p.pagelinks WHERE pl_namespace = 0 AND pl_title = "Q884" AND pl_from_namespace = wd.page_namespace
)
#GROUP BY ko.page_title HAVING COUNT(DISTINCT id) = 1
ORDER BY pp_value;
SQL

Checking query status...
