--- trunk/bin/irc-logger.pl 2007/03/18 17:14:52 54 +++ trunk/bin/irc-logger.pl 2007/04/07 17:03:57 57 @@ -602,11 +602,11 @@ my $sth = $dbh->prepare(qq{ select - nick, + trim(both '_' from nick) as nick, count(*) as count, sum(length(message)) as len from log - group by nick + group by trim(both '_' from nick) order by len desc,count desc limit $nr });