Parent Directory | Revision Log
simple visualisation of irc-logger data with nicks, first/last date and message counts
1 | dpavlin | 39 | \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 |