SELECT v.did, v.kurzbeschr, MIN(vd.timestamp) AS nextTime FROM veranstaltungen AS v INNER JOIN veranstaltungen_daten AS vd ON v.did = vd.ref_event WHERE vd.timestamp >= unix_timestamp() GROUP BY v.did ORDER BY nextTime