14.2.2023, 22:48:57node: d8943a8db48ea5d1 SELECT `Messwert`, UNIX_TIMESTAMP(Datum) AS MWDatum FROM `Messwert` WHERE `Messort_id`=1 AND `Messpunkt_id`=1 AND `Messgroesse_id`=1 AND `Datum` > DATE_SUB(NOW(), INTERVAL 1 WEEK) GROUP BY year(Datum), MONTH(Datum), DAY(Datum), HOUR(Datum) ORDER by Datum ASC; : msg.payload : array[131] array[131] [0 … 9] 0: object Messwert: 3 MWDatum: 2023-02-07T21:56:21.000Z 1: object 2: object 3: object 4: object 5: object 6: object 7: object 8: object 9: object [10 … 19] [20 … 29] [30 … 39] [40 … 49] [50 … 59] [60 … 69] [70 … 79] [80 … 89] [90 … 99] [100 … 109] [110 … 119] [120 … 129] [130 … 130]