Untitled query #73640

SQL

SELECT DISTINCT CONCAT('{','{-r|',REPLACE(Pf.page_title,'_',' '),'}','}') AS Redirect, Pt.page_title AS Target
FROM linktarget LTt
JOIN templatelinks TLt ON TLt.tl_target_id=LTt.lt_id AND TLt.tl_from_namespace=0
JOIN page Pt ON Pt.page_id=TLt.tl_from
JOIN redirect ON rd_namespace=0 AND rd_title=Pt.page_title
JOIN page Pf ON Pf.page_id=rd_from AND Pf.page_namespace=0
WHERE LTt.lt_namespace=10 AND LTt.lt_title IN ("Episode_list", "Episode_list/sublist")
AND NOT EXISTS (SELECT 1 FROM templatelinks TLf, linktarget LTf
                WHERE TLf.tl_from=Pf.page_id
                AND LTf.lt_id=TLf.tl_target_id AND LTf.lt_namespace=10
                AND LTf.lt_title IN ("R_from_television_episode", "Television_episode_redirect_handler"))
SQL

Checking query status...
