SELECT concat( p.page_namespace, ":", p.page_title, " redirects to [[User:", r.rd_title, "]]" )

AS "Redirects to user namespace"

FROM redirect r

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

WHERE p.page_namespace != 2

AND   p.page_namespace != 1

AND   p.page_namespace != 3

AND   p.page_namespace != 4

AND   p.page_namespace != 5

AND   p.page_namespace != 10

AND   p.page_namespace != 12

AND   p.page_namespace != 118

AND   r.rd_namespace = 2

#AND   p.page_title NOT LIKE '%/%'

ORDER by page_title;

​

SELECT COUNT(*)

AS "Total cross-namespace redirects to user namespace"

FROM redirect r

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

WHERE r.rd_namespace = 2

AND   p.page_namespace != 2;