反链查询模板

# 🔗 链接“.action{.title}”的内容

{{ SELECT * FROM blocks as b0 WHERE ( b0.id IN ( SELECT r1.block_id FROM refs as r1 WHERE r1.def_block_id = '.action{.id}' ) AND ( b0.type = 'h' OR b0.type = 'p' ) AND b0.parent_id NOT IN ( SELECT b1.id FROM blocks as b1 WHERE b1.type = 'i' ) ) OR ( b0.id IN ( SELECT b2.parent_id FROM blocks as b2 WHERE b2.id IN ( SELECT r2.block_id FROM refs as r2 WHERE r2.def_block_id = '.action{.id}' ) ) AND b0.type = 'i' ) order by created desc; }}