15 lines
286 B
SQL
15 lines
286 B
SQL
SELECT
|
|
ts,
|
|
raw_drain_state,
|
|
sample_valid,
|
|
drain_state,
|
|
control_state,
|
|
semantic_state,
|
|
battery_v
|
|
FROM mv_hot.drain_readings
|
|
WHERE tenant = 'tma4p1aego_lab'
|
|
AND site = 'bench_gh01'
|
|
AND product = 'climate'
|
|
AND asset = 'drain-01'
|
|
ORDER BY ts DESC
|
|
LIMIT 20; |