1242 Subquery returns more than 1 row
in:
[SELECT * FROM page_has_language phl JOIN page p ON phl.page_id=p.page_id WHERE phl.page_id=(SELECT page_id FROM page_has_language phl WHERE phl.page_url='kite-surf') AND phl.language_code='deu']