select site,farmip,avg(result) as avgres,avg(local_result) as locres,STDDEV(result) as stdres,STDDEV(local_result) as stdloc, avg(content_len), count(*) as count FROM speedtest WHERE date > DATE_SUB(NOW(),INTERVAL 30 DAY) GROUP BY site,farmip ORDER BY site,count;