select node_id, doctext
from node 
left join document on node_id = document_id
where lastedit > date_sub( current_date(), interval 10 day )
  and type_nodetype = 11 -- note
  and doctext like '%http://%'
order by lastedit desc