Quote:
Originally Posted by Nicolas.Laurent
I also use SQLiteStudio 
And my question is what is the query to export ALL the tags. I use this one and it doesn't work.
SELECT id,
author_sort,
title,
(SELECT name FROM publishers WHERE publishers.id IN (SELECT publisher from books_publishers_link WHERE book=books.id)) publisher,
(SELECT format FROM data WHERE data.book=books.id) formats,
path,
(SELECT name FROM tags WHERE tags.id IN (SELECT tag from books_tags_link WHERE book=books.id)) tags
FROM books |
I really don't see why you want to use SQL unless simply as a learning experience. A CSV catalog gives you the same information, except the path, with no hassle at all. Example attached.