SELECT time, value
FROM telemetry
WHERE datastream.key = 'temperature'
  AND time > now() - 1h
ORDER BY time DESC
LIMIT 100