Fork of Uncat'd redirs to tgts in named cats by Cryptic
This query is marked as a draft This query has been published by Cryptic.

SQL

AخA
 
WITH rcats(rcat_title) AS
(
  SELECT page_title
  FROM page
  JOIN categorylinks ON cl_from = page_id AND cl_to = 'All_redirect_categories'
  WHERE page_namespace = 14
),
uncategorized_redirs(ucr_id) AS
(
  SELECT page_id
  FROM redirect
  JOIN page ON page_id = rd_from
  LEFT JOIN categorylinks ON cl_from = page_id AND cl_to IN (SELECT rcat_title FROM rcats)
  WHERE page_namespace = 0
    AND cl_from IS NULL
),
ucrs_by_year(uby_year) AS
(
  SELECT LEFT(MIN(rev_timestamp), 4)
  FROM uncategorized_redirs
  JOIN revision ON rev_page = ucr_id
  GROUP BY ucr_id
)
SELECT uby_year,
       COUNT(*)
FROM ucrs_by_year
GROUP BY uby_year WITH ROLLUP;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...