Failed downloads in past 24 hours

SELECT s3key, round(sum(bytes_sent)/max(bytes)) as count FROM downloads LEFT JOIN downloadable ON downloads.did = downloadable.id WHERE dtime > addtime(now(),"-24:00:00") GROUP BY s3key HAVING count<1 ORDER BY count DESC