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
	tl_namespace = 10 AND tl_title = 'Soft_redirect'
	/* AND pl_namespace = -1 */
    ;

AخA
 
SELECT    CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS 'from',    CONCAT('[[{{ns:', pl_namespace, '}}:', pl_title, ']]') AS 'to'FROM pageJOIN templatelinks ON tl_from = page_id AND tl_from_namespace = page_namespaceJOIN pagelinks ON pl_from = page_id AND pl_from_namespace = page_namespaceWHERE    tl_namespace = 10 AND tl_title = 'Soft_redirect'    /* AND pl_namespace = -1 */    ;

SQL

Checking query status...