Possible partially disambiguated titles

SQL

SELECT REGEXP_REPLACE(page_title, ".*\\((.*)\\)", "\\1") AS qualifier, page_title
FROM linktarget
JOIN templatelinks ON tl_target_id=linktarget.lt_id AND tl_from_namespace=0
JOIN page ON page_id=tl_from AND page_title LIKE "%_(%)"
WHERE lt_namespace=10 AND lt_title IN ("For", "For-text", "For-multi", "About", "Other_uses", "Other_uses_of", "Redirect-distinguish-for",
 "About-distinguish", "About-distinguish-text", "Other_people", "About_other_people", "Similar_names", "Other_storms", "Other_places", "Other_ships")
ORDER BY qualifier, page_title

SQL

Checking query status...