select a.*
from blocks as a,
     (select *
      from blocks
      where id in
            (select root_id from blocks where content like '%思源%')
        and id in
            (select root_id from blocks where content like '%本地%')) as b
where a.root_id = b.id
  and (a.content like '%思源%' or a.content like '%本地%')

select * from blocks where (id in(select root_id from blocks where content like '%思源%')) and  (id in (select root_id from blocks where content like '%本地%'))