SELECT t1.id, t1.image, t1.name_it AS name, t1.text_it 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