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
Zurück zur Übersicht