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"
602392714
清零编程群