[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-cvs] [SavaneTasks] (edit) other spam stats
From: |
Beuc |
Subject: |
[Savannah-cvs] [SavaneTasks] (edit) other spam stats |
Date: |
Wed, 30 Apr 2008 19:48:21 +0000 |
??changed:
-
-- Posts per IP suspicious and per day
SELECT DATE_FORMAT(date, '%Y-%m-%d') AS day,ip, count(*) AS sum FROM
spam_stats WHERE (check_value IS NOT NULL OR check_value != '421') AND details
LIKE "%http%" GROUP BY day,ip ORDER BY day,sum;
-- Number of different IP adresses
SELECT COUNT(DISTINCT ip) FROM spam_stats;
--
forwarded from
https://savannah.gnu.org/maintenance/address@hidden://savannah.gnu.org/maintenance
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Savannah-cvs] [SavaneTasks] (edit) other spam stats,
Beuc <=