Non-space before (

Mainspace page titles containing an open-parenthesis preceded by something other than a space.

"Creation" is the earliest timestamp currently at that title; for a redirect from a page move, it'll be no earlier than that move, and in particular not the creation time of the page previously there.  Conversely, if a page has only recently been moved *to* a problematic title, perhaps from draft, this will still show the oldest revision's timestamp, not how long it was at this title.

I've made no attempt to filter out false positives yet.  However, the inclusion of non-redirects is deliberate; such pages would need to be moved anyway.

For [[WT:CSD#Improper disambiguation redirects]] circa 2 February 2024.

SQL

SELECT page_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 '[^_]\\(disambiguation);'
  AND page_is_redirect = 1
GROUP BY page_id
ORDER BY MIN(rev_timestamp) DESC;

SQL

Checking query status...