All pastes #431357 Raw Edit

Mine

public text v1 · immutable
·published 2007-04-09 16:37 UTC
rendered paste body
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