Parent Directory | Revision Log | Patch
revision 54 by dpavlin, Sun Mar 18 17:14:52 2007 UTC | revision 57 by dpavlin, Sat Apr 7 17:03:57 2007 UTC | |
---|---|---|
# | Line 602 POE::Session->create( inline_states => | Line 602 POE::Session->create( inline_states => |
602 | ||
603 | my $sth = $dbh->prepare(qq{ | my $sth = $dbh->prepare(qq{ |
604 | select | select |
605 | nick, | trim(both '_' from nick) as nick, |
606 | count(*) as count, | count(*) as count, |
607 | sum(length(message)) as len | sum(length(message)) as len |
608 | from log | from log |
609 | group by nick | group by trim(both '_' from nick) |
610 | order by len desc,count desc | order by len desc,count desc |
611 | limit $nr | limit $nr |
612 | }); | }); |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |