SELECT DISTINCT mainpage.page_title

FROM templatelinks

INNER JOIN page talkpage ON talkpage.page_id = templatelinks.tl_from

INNER JOIN page mainpage ON talkpage.page_title = mainpage.page_title

WHERE templatelinks.tl_title = "Translated_page"

AND templatelinks.tl_namespace = 10

AND templatelinks.tl_from_namespace = 1

AND mainpage.page_namespace = 0

AND mainpage.page_is_redirect = 0

AND mainpage.page_id NOT IN (SELECT ll_from FROM langlinks)