SELECT COUNT(*)

AS "Total redirects from Draft: to mainspace"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE r.rd_namespace = 0

AND   p.page_namespace = 118;

​

SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Draft:{{urlencode:",

              p.page_title, "}}&redirect=no Draft:", p.page_title, "] redirects to [[Talk:", r.rd_title, "]]" )

AS "Redirects from draft to talk, except subpages"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE p.page_namespace = 118

AND   r.rd_namespace = 1

AND   r.rd_title NOT LIKE '%/%'

ORDER by page_title;

​

SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Draft:{{urlencode:",

              p.page_title, "}}&redirect=no Draft:", p.page_title, "] redirects to [[Talk:", r.rd_title, "]]" )

AS "Redirects from draft to talk subpages"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE p.page_namespace = 118

AND   r.rd_namespace = 1

AND   r.rd_title LIKE '%/%'

ORDER by page_title;

​

SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Draft:{{urlencode:",

              p.page_title, "}}&redirect=no Draft:", p.page_title, "] redirects to [[Template:", r.rd_title, "]]" )

AS "Redirects from draft to template"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE p.page_namespace = 118

AND   r.rd_namespace = 10

ORDER by page_title;

​

SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Draft:{{urlencode:",

              p.page_title, "}}&redirect=no Draft:", p.page_title, "] redirects to [[", r.rd_title, "]]" )

AS "Cross-namespace redirects from draft namespace"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE p.page_namespace = 118

AND   r.rd_namespace != 118

AND   r.rd_namespace != 0

AND   r.rd_namespace != 2

AND   r.rd_namespace != 10

ORDER by page_title;

​

SELECT COUNT(*)

AS "Total cross-namespace redirects from draft namespace"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE r.rd_namespace != 118

AND   p.page_namespace = 118;