Se entendía por los posts algo diferente....
Entonces la consulta se vuelve simple:
Código sql:
Ver originalSELECT id, name, downloads
FROM dl_files
WHERE FROM_UNIXTIME(LAST,'%Y-%m-%d') BETWEEN DATE_SUB(NOW(),INTERVAL 30 DAY) AND DATE(NOW())
ORDER BY downloads DESC
LIMIT 5;