[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-cvs] [SavaneTasks] (edit) Average number of different apparent
From: |
Beuc |
Subject: |
[Savannah-cvs] [SavaneTasks] (edit) Average number of different apparently-spamming IP adresses per day |
Date: |
Fri, 15 Aug 2008 18:36:14 +0000 |
??changed:
- SELECT AVG(sum) FROM (SELECT ip, count(*) AS sum FROM spam_stats WHERE
(check_value IS NOT NULL OR check_value != '421') AND details LIKE "%http%"
GROUP BY ip ORDER BY sum) AS average
SELECT AVG(sum) FROM (SELECT ip, count(*) AS sum FROM spam_stats WHERE
(check_value IS NOT NULL OR check_value != '421') AND details LIKE "%http%"
GROUP BY ip ORDER BY sum) AS average;
??changed:
-
-- Average number of different apparently-spamming IP adresses per day
SELECT AVG(dist_ip) FROM (SELECT DATE_FORMAT(date, '%Y-%m-%d') AS
day,count(distinct ip) AS dist_ip FROM spam_stats WHERE (check_value IS NOT
NULL OR check_value != '421') AND details LIKE "%http%" GROUP BY day ORDER BY
day,dist_ip) AS ips_per_day;
--
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) Average number of different apparently-spamming IP adresses per day,
Beuc <=