sql- 汇总思源文档树中的 kmind 文档

呈现结果如下：

仅限于文档树中的 kmind 文档，挂件不包括。

SELECT
   '[' || b.content || '.kmind](siyuan://blocks/' || b.id || ')' AS __1____pre__kmind文件名,
    CASE
        WHEN b.updated != '' THEN b.updated
        ELSE b.created
    END AS __2____datetime__最后更新时间,
    b.created AS __3____datetime__创建时间
FROM (
    SELECT 
        path
    FROM attributes
    WHERE 
        name = 'custom-data-assets-kmind-doctree-doc'
        AND value LIKE '%.kmind'
    LIMIT -1
) kmind
LEFT JOIN (SELECT * FROM blocks WHERE type = 'd') b 
ON b.path = kmind.path
ORDER BY b.created DESC;
​