Poznámky

Manga

TABLE WITHOUT ID
	link(file.path, title) as "Název",
    author as "Autor",
    status as "Stav",
    owned as "Vlastněno",
    location as "Kde"
FROM "Main/Knihy_new/Knihy/Beletrie/Manga" OR "Knihy_new/Knihy/Beletrie/Manga"
WHERE type = "book" AND owned = true
SORT file.name ASC

Sci-Fi

TABLE WITHOUT ID
	link(file.path, title) as "Název",
    author as "Autor",
    status as "Stav",
    owned as "Vlastněno",
    location as "Kde"
FROM "Main/Knihy_new/Knihy/Beletrie/Sci-Fi" OR "Knihy_new/Knihy/Beletrie/Sci-Fi"
WHERE type = "book" AND owned = true
SORT file.name ASC

Fantasy

TABLE WITHOUT ID
	link(file.path, title) as "Název",
    author as "Autor",
    status as "Stav",
    owned as "Vlastněno",
    location as "Kde"
FROM "Main/Knihy_new/Knihy/Beletrie/Fantasy" OR "Knihy_new/Knihy/Beletrie/Fantasy"
WHERE type = "book" AND owned = true
SORT file.name ASC

Beletrie - Ostatní

TABLE WITHOUT ID
	link(file.path, title) as "Název",
    author as "Autor",
    status as "Stav",
    owned as "Vlastněno",
    location as "Kde"
FROM "Main/Knihy_new/Knihy/Beletrie/Ostatní" OR "Knihy_new/Knihy/Beletrie/Ostatní"
WHERE type = "book" AND owned = true
SORT file.name ASC

Naučné apod.

TABLE WITHOUT ID
	link(file.path, title) as "Název",
    author as "Autor",
    status as "Stav",
    owned as "Vlastněno",
    location as "Kde"
FROM "Main/Knihy_new/Knihy/Ostatní" OR "Knihy_new/Knihy/Ostatní"
WHERE type = "book" AND owned = true
SORT file.name ASC