Mine
public text v1 · immutableSELECT
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