Talk page redirects remaining after moves

Unwanted talk_page_redirects remain each time an article with not-empty talk page is moved/renamed. 
Sysops often forget to delete them. Especially annoying when the article itself has been deleted. 
Let's look for such redirects in NS2! 
There shouldn't be any older or deleted versions, since they were generated automatically.

Modified from APPER's query: https://de.wikipedia.org/wiki/Wikipedia:Bots/Anfragen/Archiv/2010-1#L.C3.B6schen_von_Benutzerdiskussionsseiten

(First query version: only such talk_page_redirects that belong to a deleted article. - Took too long & was killed)

SQL

select concat('[[Diskussion:', page_title, ']]')  as link from page as p1 
     where p1.page_namespace=1 
     and page_is_redirect
     and (select count(*) from revision where rev_page=p1.page_id and rev_deleted=0)=1
     order by p1.page_title

SQL

Checking query status...