[vz-users] Datenbankeinträge zählen ...

[W3ll Schmidt]

Ja, Daten sind da ... 8 und 14 sind die S0-Stromzähler ...

+------------+----------+
| channel_id | count(*) |
+------------+----------+
|          5 |   105114 |
|          6 |   105068 |
|          7 |    97546 |
|          8 |   396205 |
|          9 |    60446 |
|         10 |   105125 |
|         11 |   105100 |
|         12 |   103920 |
|         13 |   104036 |
|         14 |   753645 |
|         15 |    80526 |
+------------+----------+
11 rows in set (0.72 sec)

Am 3. Januar 2013 10:20 schrieb Rainer Gauweiler <volkszaehler at moppl.inka.de
>:

> SELECT channel_id, count(*) FROM volkszaehler.data where
> timestamp>135431640000 group by channel_id
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://volkszaehler.org/pipermail/volkszaehler-users/attachments/20130103/8c0b50f6/attachment.html>