分享一个查全局 kmind 的 sql

SELECT
    '[' || docs.root_id || '](siyuan://blocks/' || docs.root_id || ')' AS __2____pre__kmind文档id,
    '[' || b.hpath || '](siyuan://blocks/' || docs.doc_id || ')' AS __1____pre__文档路径
FROM (
    SELECT 
        substr(path, instr(path, '.sy')-45, 22) AS doc_id,
        root_id
    FROM attributes
    WHERE 
        name = 'custom-data-assets-kmind-doctree-doc'
        AND value LIKE '%.kmind'
    LIMIT -1
) docs
LEFT JOIN blocks b ON b.id = docs.doc_id;