SQL
x
SET STATEMENT max_statement_time = 1800 FOR
SELECT Ps.page_title, Pp.page_title
FROM templatelinks
/* Pp = Place ending in "s", e.g. "Queens", possible homograph of a plural */
JOIN page Pp ON Pp.page_id = tl_from AND Pp.page_title LIKE "%s" AND Pp.page_namespace = 0
JOIN page Ps ON Ps.page_namespace = 0 AND Ps.page_title = SUBSTRING(Pp.page_title, 1, CHAR_LENGTH(Pp.page_title)-1)
WHERE tl_namespace = 10 AND tl_title = "Infobox_settlement"
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.