Redirects to user namespace

Fork of Talk-to-mainspace redirects, except subpages by Wbm1058

This query is marked as a draft This query has been published by Wbm1058.

SQL

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;

SQL

Checking query status...