select n.id
from nodes n, metadata m
where n.id=m.id
  and ((m.name='color' and m.value='red') or
       (m.name='name' and m.value='george'))
group by n.id
having count(n.id)=2;