Themes

100 Best Books of the 21st Century

Translation

TABLE WITHOUT ID
file.link AS books,
author, status, own, rating
FROM #translation and "Area/Reading"
SORT status DESC, rating DESC, own

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #translation and "+/ReadItLater"
SORT status DESC

Biopunk / Biopolitik

TABLE WITHOUT ID
file.link AS books,
author, status, own, rating
FROM ("Area/Reading") AND (#Biopunk OR #Biopolitik)
SORT status DESC, rating DESC

TABLE WITHOUT ID
file.link AS "movies and series",
year, cast, status, rating
FROM ("Area/Entertainment") AND (#Biopunk OR #Biopolitik)
SORT status DESC, rating DESC, year DESC

Ireland

TABLE WITHOUT ID
file.link AS books,
author, status, own, rating
FROM #Ireland and "Area/Reading"
SORT rating DESC, status, own

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #Ireland and "+/ReadItLater"
SORT status DESC

TABLE WITHOUT ID
file.link AS "movies and series",
cast, year, status, rating
FROM #Ireland and "Area/Entertainment"
SORT status DESC, rating DESC, year DESC

Portugal

TABLE WITHOUT ID
file.link AS books,
author, status, own, rating
FROM #Portugal and "Area/Reading"
SORT rating DESC, status, own

TABLE WITHOUT ID
file.link AS "movies and series",
cast, year, status, rating
FROM #Portugal and "Area/Entertainment"
SORT status DESC, rating DESC, year DESC

毒與癮

TABLE WITHOUT ID
file.link AS books,
author, status, own, rating
FROM #毒與癮 AND "Area/Reading"
SORT status DESC, rating DESC

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #毒與癮 AND "+/ReadItLater"
SORT status DESC

TABLE WITHOUT ID
file.link AS "movies and series",
year, cast, status, platform
FROM #毒與癮  and "Area/Entertainment"

北歐

TABLE WITHOUT ID
file.link AS books,
author, status, own
FROM #Nordic and "Area/Reading"
SORT status DESC

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #Nordic and "+/ReadItLater"
SORT status DESC

TABLE WITHOUT ID
file.link AS "movies and series",
director, year, status
FROM #Nordic and "Area/Entertainment"
SORT director, status, year

Theatre

TASK WHERE contains(tags, "#Nordic")

語言與權力

TABLE WITHOUT ID
file.link AS books,
author, status, own
FROM #語言與權力 and "Area/Reading"
SORT status, own

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #語言與權力 and "+/ReadItLater"
SORT status DESC

Holocaust

TABLE WITHOUT ID
file.link AS books,
Chinese AS "Chinese title", 
author, status, own
FROM #Holocaust and "Area/Reading"
SORT status, own

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #Holocaust  and "+/ReadItLater"
SORT status DESC

TABLE WITHOUT ID
file.link AS "movies and series",
director, year, status
FROM #Holocaust  and "Area/Entertainment"
SORT director, status, year

Shakespear

TABLE WITHOUT ID
file.link AS books,
author, status, own
FROM #Shakespear and "Area/Reading"
SORT status, own

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #Shakespear and "+/ReadItLater"
SORT status DESC

TABLE WITHOUT ID
file.link AS "movies and series",
director, cast, year, status
FROM #Shakespear and "Area/Entertainment"
SORT file.link, status, year

Chekhov

TABLE WITHOUT ID
file.link AS books,
author, status, own
FROM #Chekhov and "Area/Reading"
SORT status, own

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #Chekhov and "+/ReadItLater"
SORT status DESC

TABLE WITHOUT ID
file.link AS "movies and series",
director, cast, year, status
FROM #Chekhov and "Area/Entertainment"
SORT director, status, year

Maggie Smith

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM "+/ReadItLater"
WHERE contains(title, "Maggie Smith") 
SORT status DESC

TABLE WITHOUT ID
file.link AS "movies and series",
year, cast, status, rating
FROM "Area/Entertainment"
WHERE contains(cast, "Maggie Smith") 
SORT status DESC, rating DESC, year

LGBT

TABLE WITHOUT ID
file.link AS books,
author, status, own, rating
FROM #LGBT and "Area/Reading"
SORT status DESC, rating DESC, own

TABLE WITHOUT ID
file.link AS articles,
author AS author,
status AS status
FROM #LGBT and "+/ReadItLater"
SORT status DESC

TABLE WITHOUT ID
file.link AS "movies and series",
cast, year, status, rating
FROM #LGBT and "Area/Entertainment"
SORT status DESC, rating DESC, year DESC