User:Wbm1058/Talk-to-user redirects
Report generated from Quarry by running:
SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Talk:{{urlencode:",
p.page_title, "}}&redirect=no Talk:", p.page_title, "] redirects to [[User:", r.rd_title, "]]" )
AS "Talk-to-user redirects, except subpages"
FROM redirect r
INNER JOIN page p ON p.page_id = r.rd_from
WHERE p.page_namespace = 1
AND r.rd_namespace = 2
AND p.page_title NOT LIKE '%/%'
ORDER by page_title;
SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Talk:{{urlencode:",
p.page_title, "}}&redirect=no Talk:", p.page_title, "] redirects to [[User:", r.rd_title, "]]" )
AS "Talk subpage-to-user redirects"
FROM redirect r
INNER JOIN page p ON p.page_id = r.rd_from
WHERE p.page_namespace = 1
AND r.rd_namespace = 2
AND p.page_title LIKE '%/%'
ORDER by page_title;
| Talk-to-user redirects, except subpages |
|---|
| Talk:Indian_general_election_2014_results redirects to User:Alertjean/Indian_general_election_2014_results |