思源笔记挂件 Query 同时查询多个 blocks 的例子

需要显示同一文档下多个块的查询内容，尝试输入代码如下：

SELECT  
    b.content AS __1____pre__概要, 
    a.content AS __2____pre__简评,
    '[' || c.content || '](siyuan://blocks/' || c.id || ')' AS __3____pre__文档
FROM
    blocks AS a
    INNER JOIN blocks AS b ON a.hpath = b.hpath
    INNER JOIN blocks AS c ON a.root_id = c.id
WHERE
    (
	b.type = 'p'
    	AND b.hpath LIKE '%[J]A comparison of estimation methods for multilevel models of spatially structured data_2017%'
    	AND b.name LIKE 'metadata'
    )
    AND
    (
	a.type = 'p' 
     	AND a.hpath LIKE '%[J]A comparison of estimation methods for multilevel models of spatially structured data_2017%'
    	AND a.content LIKE '%简评%'
    )
    AND
    (
	c.type = 'd' 
     	AND c.hpath LIKE '%[J]A comparison of estimation methods for multilevel models of spatially structured data_2017%'
    )
ORDER BY
    b.path
LIMIT 10
​

能够显示结果，供参考。