SELECT ref_event, v.did, v.kurzbeschr, vd.timestamp FROM veranstaltungen AS v INNER JOIN veranstaltungen_daten AS vd ON v.did = vd.ref_event where timestamp >= unix_timestamp() group by ref_event order by timestamp