fix #2622: include all spam levels in total spam statistic

[pmg-api.git] / src / PMG / Statistic.pm

diff --git a/src/PMG/Statistic.pm b/src/PMG/Statistic.pm
index b00fed40acfbad7d8e741bbb087e6be3935b7c58..6d279301e7559037b6fe2ec4e9b0ae517791bcec 100755 (executable)
--- a/src/PMG/Statistic.pm
+++ b/src/PMG/Statistic.pm
@@ -431,7 +431,7 @@ sub total_spam_stat {
 
     my $sth = $rdb->{dbh}->prepare("SELECT spamlevel, COUNT(spamlevel) AS count FROM CStatistic " .
                                   "WHERE virusinfo IS NULL and time >= ? AND time < ? AND ptime > 0 AND spamlevel > 0 " .
-                                  "GROUP BY spamlevel ORDER BY spamlevel LIMIT 10");
+                                  "GROUP BY spamlevel ORDER BY spamlevel");
     $sth->execute($from, $to);
 
     my $res = $sth->fetchall_arrayref({});