In case anyone is interested besides David, here are the titles to go with the list of numbers Marcello has provided. Notice that the instructional books are quite clearly the most often downloaded. PG number Downloads Title 8177 | 405 The Esperanto Teacher 16967 | 347 English-Esperanto Dictionary 7787 | 303 A Complete Grammar of Esperanto 17482 | 214 La Aventuroj de Alicio en Mirlando 11511 | 183 Robinsono Kruso 17945 | 148 Mark Twain: Tri Noveloj 8224 | 145 Fundamenta Krestomatio 17425 | 126 La Falo de Usxero-Domo 17665 | 98 Mia Kontrabandulo 11307 | 66 El la Biblio On Tue, 28 Mar 2006, Marcello Perathoner wrote:
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=>