blob: c4cf1d39d5973fe4d98735f0dc3def0acb23f323 (
plain)
1
2
3
4
5
6
7
8
9
|
SELECT
filename,
size
FROM dtf.madelines_files
WHERE
size = (SELECT MAX(size) FROM dtf.madelines_files WHERE created_at BETWEEN '2059-12-03 23:59:59'::timestamp - interval '1 week' AND '2059-12-03 23:59:59'::timestamp)
AND created_at BETWEEN '2059-12-03 23:59:59'::timestamp
- interval '1 week' AND '2059-12-03 23:59:59'::timestamp
ORDER BY filename
|
