Untranscluded XNRs to Template:

For [[WP:RAQ#Zero transclusion cross namespace redirects to template space]] circa 7 Feb 2020.

Redirects to the template namespace from outside the template namespace, where the redirect is not itself transcluded.

SQL

SELECT CONCAT('[[',
              CASE page_namespace
                WHEN 0 THEN '' WHEN 1 THEN 'Talk:'
                WHEN 2 THEN 'User:' WHEN 3 THEN 'User talk:'
                WHEN 4 THEN 'Wikipedia:' WHEN 5 THEN 'Wikipedia talk:'
                WHEN 11 THEN 'Template talk:'
                WHEN 12 THEN 'Help:'
                WHEN 15 THEN 'Category talk:'
                WHEN 100 THEN 'Portal:'
                WHEN 118 THEN 'Draft:'
                WHEN 828 THEN 'Module:' WHEN 829 THEN 'Module talk:'
                ELSE CONCAT('{{ns:', page_namespace, '}}:')
              END,
              page_title, ']]') AS 'redirect from',
       CONCAT('[[Template:', rd_title, ']]') AS 'redirect to',
       page_touched,
       page_namespace
FROM redirect
JOIN page ON page_id = rd_from
LEFT JOIN templatelinks ON tl_namespace = page_namespace AND tl_title = page_title
WHERE rd_namespace = 10
  AND page_namespace != 10
  AND tl_from IS NULL;

SQL

Checking query status...