[Savannah-cvs] [SavaneTasks] (edit) Average number of different apparently-spamming IP adresses per day

[Beuc]

??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