#/temporally-named redirects

The number of currently existing redirects in mainspace either starting with "Untitled " or "Upcoming ", or containing "(untitled" or "(upcoming"; and the number of pages in mainspace (redirects or not) deleted in 2022 with such titles.

For [[WT#Formerly untitled/upcoming media]] circa 5 September 2022.

See also query 67287.

SQL

SELECT COUNT(*) AS '#/existing mainspace redirects'
FROM page
WHERE page_namespace = 0
  AND page_is_redirect = 1
  AND (page_title LIKE '%(untitled%'
       OR page_title LIKE '%(upcoming%'
       OR page_title LIKE 'Untitled_%'
       OR page_title LIKE 'Upcoming_%');
SELECT COUNT(*) AS '#/deleted mainspace pages in 2022'
FROM logging_logindex
WHERE log_type = 'delete'
  AND log_action = 'delete'
  AND log_timestamp >= '2022'
  AND log_namespace = 0
  AND (log_title LIKE '%(untitled%'
       OR log_title LIKE '%(upcoming%'
       OR log_title LIKE 'Untitled_%'
       OR log_title LIKE 'Upcoming_%');

SQL

Checking query status...