SQL
AخA
SELECT Pd.page_title
FROM categorylinks
JOIN page Pd ON Pd.page_id = cl_from AND Pd.page_title REGEXP "_and_[a-z]" AND Pd.page_namespace = 0
JOIN page Pa ON Pa.page_namespace = 0 AND Pa.page_is_redirect = 0
AND Pa.page_title = CONCAT(SUBSTRING_INDEX(Pd.page_title, "_and_", 1),"_and_",
UPPER(CONVERT(SUBSTRING(Pd.page_title, LOCATE("_and_", Pd.page_title)+5, 1) USING latin1)),
SUBSTRING(Pd.page_title, LOCATE("_and_", Pd.page_title)+6))
WHERE cl_to = "All_disambiguation_pages" AND cl_type = "page"
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.