enwiki pages transcluding {{soft redirect}} and linking to Special:

SQL

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 = 4
    -- [[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') LIMIT 10;

SQL

Checking query status...