Noch

bis

HIPPO Logo

Terminkalender

SELECT DATE_FORMAT(NOW(), '%Y-%m-%d') as TODAY, t.DID as DID, t.TID, MIN(STR_TO_DATE(CONCAT(t.Day, ',', t.Month, ',', t.Year), '%d,%m,%Y')) as STARTDATE, MAX(STR_TO_DATE(CONCAT(t.Day, ',', t.Month, ',', t.Year), '%d,%m,%Y')) as ENDDATE, Start_Time, End_Time, location, Information, veranstalter, Event, city, lat, lng FROM seschat4_5.NewData as t GROUP BY t.TID HAVING DID = 100 AND ENDDATE >= TODAY ORDER BY STARTDATE ASC LIMIT 0, 10 Zurück zur Übersicht