1
TABLE WITHOUT ID
2
  category AS "分类",
3
  file.tags AS "标签",
4
  dateformat(file.ctime, "yyyy/MM/dd") AS "创建日期",
5
  file.link AS "笔记名称"
6
WHERE !category OR !file.tags OR length(file.tags) = 0
7
SORT category ASC, file.ctime DESC