David Starner wrote:
Team Esperanto on DP was wondering about the most downloaded Esperanto books. It would be interesting at least as a one-time thing.
We keep records for the last 30 days only. gutenberg=> SELECT scores.book_downloads.fk_books, SUM (downloads) AS downloads gutenberg-> FROM scores.book_downloads, mn_books_langs gutenberg-> WHERE mn_books_langs.fk_langs = 'eo' gutenberg-> AND mn_books_langs.fk_books = scores.book_downloads.fk_books gutenberg-> GROUP BY scores.book_downloads.fk_books gutenberg-> ORDER BY downloads DESC; fk_books | downloads ----------+----------- 8177 | 405 16967 | 347 7787 | 303 17482 | 214 11511 | 183 17945 | 148 8224 | 145 17425 | 126 17665 | 98 11307 | 66 (10 rows) gutenberg=> -- Marcello Perathoner webmaster@gutenberg.org