SELECT t1.id, t1.image, t1.name_de AS name, t1.text_de AS text, t2.pageID FROM ritten23_site_teaserContent t1 INNER JOIN ritten23_site_teaserContent_kategorien t2 ON t1.kID=t2.id WHERE t1.id=117