projects
/
eg5120
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
remove all output without DEBUG=1 for cron use
[eg5120]
/
queries.sql
1
select count(*),min(time),max(time),
2
sensor_type,
3
addr as mac,
4
json->'sensor_name' as sensor_name
5
from eg5120
6
group by
7
sensor_type,
8
addr,
9
sensor_name
10
order by sensor_type asc, max desc
11
;
12