[Nicolas.Laurent]

Originally Posted by ownedbycats

My software of choice is SQLiteStudio.

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