Parent Directory | Revision Log
simple visualisation of irc-logger data with nicks, first/last date and message counts
1 | \c irc-logger |
2 | select |
3 | trim(both '_`0123456789' from nick) as label, |
4 | count(*) as messages_valueType_number, |
5 | min(time) as first, |
6 | max(time) as last |
7 | from log |
8 | group by trim(both '_`0123456789' from nick) |
9 | ; |
ViewVC Help | |
Powered by ViewVC 1.1.26 |