TEST 1 - Quarry

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 page_namespace = 0

#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;
SQL

Checking query status...
