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

[W3ll Schmidt]

Nischt ...

Empty set (0.78 sec)

Irgendwie stimmt was mit dem "timestamp' nicht ...

Schaumal einmal grösser als 01.12.2012, zweite Abfrage grösser als
01.01.2013 ->

mysql> SELECT channel_id, count(*) FROM volkszaehler.data where
timestamp>135434160000 group by channel_id;
+------------+----------+
| channel_id | count(*) |
+------------+----------+
|          5 |   105273 |
|          6 |   105227 |
|          7 |    97705 |
|          8 |   396709 |
|          9 |    60588 |
|         10 |   105283 |
|         11 |   105259 |
|         12 |   104079 |
|         13 |   104195 |
|         14 |   754736 |
|         15 |    80685 |
+------------+----------+
11 rows in set (0.74 sec)

mysql> SELECT channel_id, count(*) FROM volkszaehler.data where
timestamp>135702000000  group by channel_id;
+------------+----------+
| channel_id | count(*) |
+------------+----------+
|          5 |   105274 |
|          6 |   105228 |
|          7 |    97705 |
|          8 |   396710 |
|          9 |    60588 |
|         10 |   105284 |
|         11 |   105259 |
|         12 |   104080 |
|         13 |   104195 |
|         14 |   754738 |
|         15 |    80685 |
+------------+----------+
11 rows in set (0.73 sec)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://volkszaehler.org/pipermail/volkszaehler-users/attachments/20130103/57cf4096/attachment.html>