Downloads per day for the past 30 days

SELECT ddate as `date`, count(*) as count FROM (SELECT date(dtime) ddate,s3key,round(sum(bytes_sent)/max(bytes)) as count FROM downloads LEFT JOIN downloadable ON downloads.did = downloadable.id WHERE dtime > DATE_ADD(NOW(), INTERVAL -30 DAY) GROUP BY s3key,date(dtime) HAVING count>=1 ) a GROUP BY ddate