User:Cryptic/Improper disambiguation redirects

--

SELECT CASE WHEN page_is_redirect = 1
         THEN CONCAT(CHR(14853303), '{', '{!r', CHR(124), page_title, '}', '}')
         ELSE CONCAT('[', '[', page_title, ']', ']')
       END AS title,
       CAST(MIN(rev_timestamp) AS DATETIME) AS creation
FROM page
JOIN revision ON rev_page = page_id
WHERE page_namespace = 0
  AND page_title RLIKE '[^_]\\('
GROUP BY page_id
ORDER BY MIN(rev_timestamp) DESC;
--

|remove_underscores = 1|pagination = 1000}}

Unsorted

/1
/2
/3
/4
/5
/6
/7
/8
/9
/10
/11
/12
/13
~~/14~~
~~/15~~

Sorted

/deletable - likely to be deleted with this criterion (when a redirect)
/chemical - names of chemicals and chemical processes. This is a proper subset of proper names, below, but is by far the most common case of it.
/proper name - proper names of the subject, mostly songs, bands, and military designations
/suffix - parenthetical letters, mostly suffixes
/misc - mathematical formulae, emoticons, and other clearly non-disambiguator-like typography
/section - section names, typically of legal documents. This is a proper subset of proper names, above; I've kept it separate because it was one of the earliest counterexamples raised.