SELECT janus_events.*, janus_locations.picture as picture,janus_locations.text as text FROM janus_events left join janus_locations on janus_events.location =janus_locations.titel where janus_events.id=99