Producing the Digital Body
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
| date | count |
|---|---|
| 2024-04-01 | 2667 |
| 2024-04-02 | 2412 |
| 2024-04-03 | 3003 |
| 2024-04-04 | 2455 |
| 2024-04-05 | 1692 |
| 2024-04-06 | 924 |
| 2024-04-07 | 961 |
| 2024-04-08 | 946 |
| 2024-04-09 | 1010 |
| 2024-04-10 | 824 |
| 2024-04-11 | 7405 |
| 2024-04-12 | 1766 |
| 2024-04-13 | 1057 |
| 2024-04-14 | 544 |
| 2024-04-15 | 704 |
| 2024-04-16 | 2562 |
| 2024-04-17 | 1598 |
| 2024-04-18 | 1644 |
| 2024-04-19 | 2687 |
| 2024-04-20 | 1813 |
| 2024-04-21 | 1024 |
| 2024-04-22 | 672 |
| 2024-04-23 | 1165 |
| 2024-04-24 | 1423 |
| 2024-04-25 | 1510 |
| 2024-04-26 | 1310 |
| 2024-04-27 | 1605 |
| 2024-04-28 | 1456 |
| 2024-04-29 | 1088 |
| 2024-04-30 | 1110 |
| 2024-05-01 | 464 |