MobileRead Forums - View Single Post - _mcs_authors_by_book does not reflect the true content of the library

Angelo.Mascaro · 01-04-2020, 06:02 AM

I searched the table _mcs_authors_by_book with DB Browser for SQLite with this query:

SELECT authorname, count(book) AS totalbook
FROM _mcs_authors_by_book
GROUP BY authorname
ORDER BY totalbook DESC

because I wanted to know the authors with more books.
I discovered that this table does not reflect the true content of the library and all the deleted/moved books are still considered. The field book in this table points to id of books that are no longer in the table books
Would it be possible to fix this modifying the TRIGGER books_delete_trg in one of the next versions?

01-04-2020, 06:02 AM	#1
Angelo.Mascaro Junior Member Posts: 6 Karma: 10 Join Date: Oct 2019 Location: Karlsruhe Device: Kindle	_mcs_authors_by_book does not reflect the true content of the library I searched the table _mcs_authors_by_book with DB Browser for SQLite with this query: SELECT authorname, count(book) AS totalbook FROM _mcs_authors_by_book GROUP BY authorname ORDER BY totalbook DESC because I wanted to know the authors with more books. I discovered that this table does not reflect the true content of the library and all the deleted/moved books are still considered. The field book in this table points to id of books that are no longer in the table books Would it be possible to fix this modifying the TRIGGER books_delete_trg in one of the next versions?