SELECT

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

    CONCAT('[[:', iwl_prefix, ':', iwl_title, ']]') AS 'to'

FROM page

JOIN templatelinks ON tl_from = page_id

JOIN iwlinks ON iwl_from = page_id AND iwl_prefix = 'fr'

WHERE

    page_namespace = 0 -- main namespace

    -- [[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');