<div dir="ltr"><div class="gmail_extra">Ja, Daten sind da ... 8 und 14 sind die S0-Stromzähler ...<br><br><font size="1"><span style="font-family:courier new,monospace">+------------+----------+<br>| channel_id | count(*) |<br>
+------------+----------+<br>| 5 | 105114 |<br>| 6 | 105068 |<br>| 7 | 97546 |<br>| 8 | 396205 |<br>| 9 | 60446 |<br>| 10 | 105125 |<br>| 11 | 105100 |<br>
| 12 | 103920 |<br>| 13 | 104036 |<br>| 14 | 753645 |<br>| 15 | 80526 |<br>+------------+----------+<br>11 rows in set (0.72 sec)</span></font><br></div><div class="gmail_extra"><br>
<div class="gmail_quote">Am 3. Januar 2013 10:20 schrieb Rainer Gauweiler <span dir="ltr"><<a href="mailto:volkszaehler@moppl.inka.de" target="_blank">volkszaehler@moppl.inka.de</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
SELECT channel_id, count(*) FROM volkszaehler.data where timestamp>135431640000 group by channel_id</blockquote></div><br></div></div>