home / bibliothek

Zuletzt ausgelesen

Die zuletzt beendeten Bücher (für die Eingangshalle).

Custom SQL query returning 8 rows (hide)

SELECT m.title, m.creator, m.cover_path AS cover, r.finished_at FROM reading r JOIN copy c ON c.id = r.copy_id JOIN media m ON m.id = c.media_id WHERE r.state = 'finished' AND r.finished_at IS NOT NULL AND r.deleted_at IS NULL AND c.deleted_at IS NULL AND m.deleted_at IS NULL AND m.media_type IN ('book', 'ebook') ORDER BY r.finished_at DESC, r.id DESC LIMIT 8

Edit SQL

This data as json, CSV

titlecreatorcoverfinished_at
Magicians: the New Class Lev Grossman 9781684155651.jpg 2026-11-16
Gideon the Ninth: Ninth House 1 Tamsyn Muir 9781664743328.jpg 2026-10-12
Normal und die Zero Heroes Marc-Uwe Kling 9783498002787.jpg 2025-11-16
Roter Drache Thomas Harris 9783453025424.jpg 2024-11-16
1984 George Orwell m142.jpg 2024-11-16
Die Sonne, so strahlend und Schwarz Chantal-Fleur Sandjon 9783522204095.jpg 2024-11-12
Iron Widow: Rache im Herzen Xiran Jay Zhao 9783641283452.jpg 2024-11-12
City of trees Chantal-Fleur Sandjon 9783522202879.jpg 2024-07-12
Powered by Datasette · Queries took 0.514ms