_mcs_authors_by_book does not reflect the true content of the library

[Angelo.Mascaro]

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?

[chaley]

I think you are looking at a table maintained by [GUI Plugin] Multi-Column Search. If so then you should make this request in that plugin's thread.

[Angelo.Mascaro]

Originally Posted by chaley

I think you are looking at a table maintained by [GUI Plugin] Multi-Column Search. If so then you should make this request in that plugin's thread.

Thank you very much! Now I realize something obvious: in the database a plugin can create its own tables.
Is there any way to move my post to another thread? Otherwise, I just create a new one there.
AM

[chaley]

Moderator Notice
Original post duplicated in plugins forum. This thread is closed