Extract complet Sensor values from Database

Configuration
3

Thanks!

SELECT mean,min,max,from_unixtime(start_ts) 
FROM statistics WHERE metadata_id =
 (  SELECT id     FROM       statistics_meta     
WHERE       statistic_id = 'sensor.strom_waschmaschine_voltage');

Did the trick!

2 Likes