SELECT n.*
  FROM nodes n, meta_data md1, meta_data md2
 WHERE md1.name = ?
   AND md1.value = ?
   AND n.id = md1.node_id
   AND md2.name = ?
   AND md2.value = ?
   AND n.id = md2.node_id
 ORDER BY 1