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-14 | 153 |
| 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 | 938 |
| 2024-05-02 | 1822 |
| 2024-05-03 | 1017 |
| 2024-05-04 | 528 |
| 2024-05-05 | 790 |
| 2024-05-06 | 1624 |
| 2024-05-07 | 702 |
| 2024-05-08 | 680 |
| 2024-05-09 | 4107 |
| 2024-05-10 | 5517 |
| 2024-05-11 | 1013 |
| 2024-05-12 | 498 |
| 2024-05-13 | 1481 |
| 2024-05-14 | 1647 |
| 2024-05-15 | 125 |