Temperaturen, Sonne und Regen
SELECT DATE_FORMAT(Datum, '%a. %d.%m.%y') AS AnzeigeDatum, UNIX_TIMESTAMP(DATE_FORMAT(Datum, '%y.%m.%d 00:00:00')) AS MyDateTime, sonnenschein.Dauer, Rain.Regen, Temp.MinTemp, Temp.AvgTemp, Temp.MaxTemp FROM sonnenschein LEFT JOIN ( SELECT DATE_FORMAT(DatumZeit, '%Y-%m-%d') AS MyDatum, SUM(Regen) AS Regen FROM wetter Group By MyDatum ) AS Rain ON Rain.MyDatum = sonnenschein.Datum LEFT JOIN ( SELECT DATE_FORMAT(DatumZeit, '%Y-%m-%d') AS JoinDatum, DATE_FORMAT(DatumZeit, '%d.%m.%y') AS SortDatum, DATE_FORMAT(DatumZeit, '%a. %d.%m.%y') AS MyDatum, UNIX_TIMESTAMP(DatumZeit) AS MyDateTime, MIN(Aussentemperatur) AS MinTemp, AVG(Aussentemperatur) AS AvgTemp, MAX(Aussentemperatur) AS MaxTemp FROM waermepumpe WHERE (DATEDIFF(CURDATE(),DatumZeit) < 60) GROUP BY JoinDatum ) AS Temp ON Temp.JoinDatum = sonnenschein.Datum WHERE (DATEDIFF(CURDATE(),sonnenschein.Datum) < 60) ORDER BY sonnenschein.Datum DESCKeine Daten gefunden!