日记

table title AS "标题",date AS "创建时间"
from "日记"
where draft=true
sort date desc

草稿箱

table title AS "标题",date AS "创建时间"
from "post"
where draft=true
sort date desc

已发布

table title AS "标题",date AS "创建时间"
from "post"
where draft=false
sort date desc