Skip to content

projects

My Writings

TABLE WITHOUT ID
file.link AS "Title",
dateformat(created, "yyyy-MM-dd") AS "Date"
FROM #writing
WHERE file.name != this.file.name
SORT created ASC
  • in projects
  • 3 min read

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
  • in projects
  • 2 min read

My Watchlist

TV Series

Waiting

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS "title",
year, cast, platform, accent
FROM #tv and "Area/Entertainment" WHERE status = "waiting"
SORT year, platform

In Progress

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS "title",
year, cast, platform, accent
FROM #tv and "Area/Entertainment" WHERE status = "in progress"
SORT year

Finished in 2025

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS "title",
year, cast, rating
FROM #tv and "Area/Entertainment"
WHERE status = "finished"
 AND date.finished >= date(2025-01-01) 
 AND date.finished <= date(2025-12-31)
SORT rating DESC, year ASC

Movies

Waiting

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS title,
year, director, cast
FROM #movie and "Area/Entertainment" WHERE status = "waiting"
SORT director, year

Finished in 2025

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS title,
year, director, cast, rating
FROM #movie and "Area/Entertainment"
WHERE status = "finished" 
 AND date.finished >= date(2025-01-01) 
 AND date.finished <= date(2025-12-31)
SORT rating DESC

Finished in 2024

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS title,
year, director, cast, rating
FROM #movie and "Area/Entertainment"
WHERE status = "finished"
WHERE status = "finished" 
 AND date.finished >= date(2024-01-01) 
 AND date.finished <= date(2024-12-31)
SORT rating DESC

Theatre

Waiting

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS title,
writer, cast, year
FROM #theatre and "Area/Entertainment" WHERE status = "waiting"
SORT writer, year

Finished

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS title,
writer, cast, year
FROM #theatre and "Area/Entertainment" WHERE status = "finished"
SORT year, writer

Shakespear

TABLE WITHOUT ID
"![|50](" + poster + ")" as cover,
file.link AS title,
cast, year, status
FROM #Shakespear  and "Area/Entertainment"
SORT status, year

Henrik Ibsen