SELECT

    CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS 'from',

    CONCAT('[[{{ns:', pl_namespace, '}}:', pl_title, ']]') AS 'to'

FROM page

JOIN templatelinks ON tl_from = page_id AND tl_from_namespace = page_namespace

JOIN pagelinks ON pl_from = page_id AND pl_from_namespace = page_namespace

WHERE

    pl_namespace = -1

    -- [[Template:Soft redirect]] and current redirects to it

    AND tl_namespace = 10

    AND (tl_title = 'Soft_redirect'

         OR tl_title = 'Interwiki_redirect'

         OR tl_title = 'SoftRedirect'

         OR tl_title = 'Soft_Redirect'

         OR tl_title = 'Softredirect'

         OR tl_title = 'Softredir'

         OR tl_title = 'Soft_link'

         OR tl_title = 'Soft_redir'

         OR tl_title = 'Soft');