Lecture Notes

TABLE status, choice(linked=1, "✅","❌") as "linked", choice(clean=1, "✅","❌") as "clean"  
FROM #class_notes 
WHERE contains(subject, this.file.link)
	AND type="lecture_note" 
	AND file.name != this.file.name
SORT file.name asc

Main Topics

LIST
FROM #class_notes  
WHERE subject=this.file.link
	AND type="main_topic"
SORT file.name ASC

Concepts

TABLE status, parent as "Parent Topic", filter(file.inlinks, (i) => contains(i.type, "lecture_note")) as Lectures
FROM #concepts 
WHERE contains(subject, this.file.link)
SORT file.name asc