需要显示同一文档下多个块的查询内容,尝试输入代码如下:
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
能够显示结果,供参考。
欢迎来到这里!
我们正在构建一个小众社区,大家在这里相互信任,以平等 • 自由 • 奔放的价值观进行分享交流。最终,希望大家能够找到与自己志同道合的伙伴,共同成长。
注册 关于