temporally-named redirects

Mainspace redirects whose titles either start with "Untitled " or "Upcoming ", or contain "(untitled" or "(upcoming"; whether they're in [[Category:Redirects from moves]], the timestamp of their first revision, and what they redirect to.

For [[WT:CSD#Formerly untitled/upcoming media]] circa 12 September 2022.

See also query 67151.

SQL

SELECT CAST(MIN(rev_timestamp) AS DATETIME) AS `creation`,
       EXISTS (SELECT 1
               FROM categorylinks
               WHERE cl_from = page_id
               AND cl_to = 'Redirects_from_moves') AS `R from move?`,
       page_title,
       rd_title
FROM page
JOIN revision ON rev_page = page_id
LEFT JOIN redirect ON rd_from = page_id
WHERE page_is_redirect = 1
  AND page_namespace = 0
  AND (page_title LIKE '%(untitled%'
       OR page_title LIKE '%(upcoming%'
       OR page_title LIKE 'Untitled\_%'
       OR page_title LIKE 'Upcoming\_%')
GROUP BY page_title
ORDER BY MIN(rev_timestamp) ASC;

SQL

Checking query status...