TABLE WITHOUT ID
"" as cover,
file.link AS "title",
year, cast, platform, accent
FROM #tv and "Area/Entertainment" WHERE status = "waiting"
SORT year, platform
TABLE WITHOUT ID
"" as cover,
file.link AS "title",
year, cast, platform, accent
FROM #tv and "Area/Entertainment" WHERE status = "in progress"
SORT year
TABLE WITHOUT ID
"" 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
TABLE WITHOUT ID
"" as cover,
file.link AS title,
year, director, cast
FROM #movie and "Area/Entertainment" WHERE status = "waiting"
SORT director, year
TABLE WITHOUT ID
"" 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
TABLE WITHOUT ID
"" 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
TABLE WITHOUT ID
"" as cover,
file.link AS title,
writer, cast, year
FROM #theatre and "Area/Entertainment" WHERE status = "waiting"
SORT writer, year
TABLE WITHOUT ID
"" as cover,
file.link AS title,
writer, cast, year
FROM #theatre and "Area/Entertainment" WHERE status = "finished"
SORT year, writer
TABLE WITHOUT ID
"" as cover,
file.link AS title,
cast, year, status
FROM #Shakespear and "Area/Entertainment"
SORT status, year