ASELF JOIN可能会有所帮助，并且如果不是出于性能原因，通常是对许多嵌套查询的更可取的解决方案。

在您的情况下，请尝试：

SELECT movies_ru.title 
 FROM movies AS movies_ru 
 JOIN movies AS movies_en 
 ON movies_ru.id = movies_en.id
 WHERE movies_ru.lang = "ru"
 AND movies_en.lang = "en"
 AND movies_en.title = "The English Title"