title: MySQL INSERT with multiple nested SELECTs
body: <p>Is a query like this possible? MySQL gives me an Syntax error. Multiple insert-values with nested selects...</p>
  
  <pre><code>INSERT INTO pv_indices_fields (index_id, veld_id)
  VALUES
  ('1', SELECT id FROM pv_fields WHERE col1='76' AND col2='val1'),
  ('1', SELECT id FROM pv_fields WHERE col1='76' AND col2='val2')
  </code></pre>