Pages in cat, w/title by regex

Pages in [[Category:Disambiguation pages]] whose titles match the regex /^([0-9]*\.)?[0-9]+(_\(|$)/

In human-readable terms, that means:
* Starting from the beginning of the title,
* Optionally, zero or more digits followed by a period
* One or more digits
* Either of:
** An underscore then an open parenthesis, or
** The end of the title.

The regex is tested only against the part of the title that doesn't include the pages' namespaces (e.g., if [[Template:42]] were in this category, it would match), but here I expect all results to be in the main namespace anyway.

For [[WP:HD#Number disambiguation]] circa 15 Sep 2023.

SQL

SELECT page_title
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE cl_to = 'Disambiguation_pages'
  AND page_title REGEXP '^([0-9]*\\.)?[0-9]+(_\\(|$)';

SQL

Checking query status...