Genlibrusec

SELECT bm.title, bh.hash FROM books_metadata bm JOIN books_to_hashes bth ON bm.id = bth.metadata_id JOIN books_hashes bh ON bth.hash_id = bh.id WHERE bm.language = 'en' AND bm.year BETWEEN 1950 AND 1970 ORDER BY bh.last_seen DESC;