SELECT p.uid, url.speaking_url FROM pages p LEFT JOIN tx_realurl_urldata url ON url.page_id = p.uid WHERE p.filename='christus_und_das_meister-sch�ler-verh�ltnis.htm' AND p.lang='de';