enwiki soft redirs to fr:

Mainspace pages on enwiki that both transclude {{soft redirect}} (or any of several redirects to it) and link to a page on fr: (from anywhere on the page, not necessarily from within the {{soft redirect}} template).

SQL

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

SQL

Checking query status...