Bei mir sieht das Ganze so aus, ich hätte noch Status 4 und 131 zusätzlich im Angebot.
Code
MariaDB [p4]> select * from samples where address = "1" and type = "UD" and time > "2023-01-01 00:00:00" group by text order by value asc;
+---------+------+-----------+---------------------+------------+------------+--------+-------------------+---------+
| address | type | aggregate | time | inssp | updsp | value | text | samples |
+---------+------+-----------+---------------------+------------+------------+--------+-------------------+---------+
| 1 | UD | S | 2023-03-15 15:03:12 | 1678888992 | 1678888992 | 0.00 | STÖRUNG | 1 |
| 1 | UD | S | 2023-01-10 16:14:01 | 1673363641 | 1673363641 | 1.00 | Kessel Aus | 1 |
| 1 | UD | S | 2023-01-10 17:58:41 | 1673369921 | 1673369921 | 2.00 | Anheizen | 1 |
| 1 | UD | S | 2023-01-10 18:07:41 | 1673370461 | 1673370461 | 3.00 | Heizen | 1 |
| 1 | UD | S | 2023-01-15 16:12:53 | 1673795573 | 1673795573 | 4.00 | Feuererhaltung | 1 |
| 1 | UD | S | 2023-01-10 17:56:21 | 1673369781 | 1673369781 | 7.00 | Vorbereitung | 1 |
| 1 | UD | S | 2023-01-10 18:01:41 | 1673370101 | 1673370101 | 8.00 | Vorwärmen | 1 |
| 1 | UD | S | 2023-01-10 18:05:21 | 1673370321 | 1673370321 | 9.00 | Zünden | 1 |
| 1 | UD | S | 2023-01-10 19:19:11 | 1673374751 | 1673374751 | 11.00 | Abstellen Warten1 | 1 |
| 1 | UD | S | 2023-01-10 19:34:11 | 1673375651 | 1673375651 | 13.00 | Abstellen Warten2 | 1 |
| 1 | UD | S | 2023-01-10 19:39:11 | 1673375951 | 1673375951 | 15.00 | Abreinigen | 1 |
| 1 | UD | S | 2023-01-10 16:16:11 | 1673363771 | 1673363771 | 19.00 | Betriebsbereit | 1 |
| 1 | UD | S | 2023-03-08 00:18:03 | 1678231083 | 1678231083 | 131.00 | � | 1 |
+---------+------+-----------+---------------------+------------+------------+--------+-------------------+---------+
Alles anzeigen