SELECT n.id
  FROM nodes n, meta_data md
 WHERE md.name = "color"
   AND md.value = "green"
   AND n.id = md.node_id
 ORDER BY 1