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

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

AS "Mainspace-to-talk redirects"

FROM redirect r

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

WHERE r.rd_namespace != 0

AND   r.rd_namespace != 4

AND   r.rd_namespace != 10

AND   r.rd_namespace != 11

AND   r.rd_namespace != 12

AND   r.rd_namespace != 14

AND   r.rd_namespace != 100

AND   r.rd_namespace != -1

AND   p.page_namespace = 0

ORDER by page_title;

​

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

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

AS "Mainspace-to-template talk redirects"

FROM redirect r

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

WHERE p.page_namespace = 0

AND   r.rd_namespace = 11

ORDER by page_title;

​

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

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

AS "Mainspace-to-special page redirects"

FROM redirect r

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

WHERE p.page_namespace = 0

AND   r.rd_namespace = -1

ORDER by page_title;

​

SELECT COUNT(*)

AS "Total cross-namespace redirects from mainspace to project"

FROM redirect r

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

WHERE r.rd_namespace = 4

AND   p.page_namespace = 0;

​

SELECT COUNT(*)

AS "Total cross-namespace redirects from mainspace to template"

FROM redirect r

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

WHERE r.rd_namespace = 10

AND   p.page_namespace = 0;

​

SELECT COUNT(*)

AS "Total cross-namespace redirects from mainspace to help"

FROM redirect r

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

WHERE r.rd_namespace = 12

AND   p.page_namespace = 0;

​

SELECT COUNT(*)

AS "Total cross-namespace redirects from mainspace to category"

FROM redirect r

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

WHERE r.rd_namespace = 14

AND   p.page_namespace = 0;

​

SELECT COUNT(*)

AS "Total cross-namespace redirects from mainspace to portal"

FROM redirect r

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

WHERE r.rd_namespace = 100

AND   p.page_namespace = 0;

​

SELECT COUNT(*)

AS "Total cross-namespace redirects from mainspace"

FROM redirect r

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

WHERE r.rd_namespace != 0

AND   p.page_namespace = 0;