相关帖子
-
wilsons • • 1付费者 捐赠者
试试这个
select * from blocks where path like '%/20250128095334-2lz30ur%' and type = 'd' and root_id not in ( select distinct root_id from blocks where path like '%/20250128095334-2lz30ur%' and type != 'd' and content != '' )
如果不包含父文档本身,可以 sql 最后添加 and root_id != '20250128095334-2lz30ur'
-
试试这个
select * from blocks where path like '%/20250128095334-2lz30ur%' and type = 'd' and root_id not in ( select distinct root_id from blocks where path like '%/20250128095334-2lz30ur%' and type != 'd' and content != '' )
如果不包含父文档本身,可以 sql 最后添加 and root_id != '20250128095334-2lz30ur'
- 其他回帖