Comment too large
Hi
I search a plugin or a simple command to search amidst my books all books with too large comment (exemple : > 5000 car )
Have you an idea ?
Thanks
PS: can you delete the same post in related tools please
PS : i use sql to do that , but i will prefere to do with calibre interface
SELECT books.id as booksid, title, author_sort as author, books.series_index as serie_index, series.name as serie_name , length(comments.text)
FROM books left outer join books_series_link on books.id = books_series_link.book left outer join comments on comments.book = books.id left outer join series on books_series_link.series = series.id
where length(comments.text) > 5000 order by length(comments.text) ;
Last edited by Doum; 12-09-2023 at 10:47 AM.
|