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;