title: SQL Key value table--select ids that have multiple keys
body: <p>I need to obtain records in a key-value table with the following structure:</p>
  
  <pre><code>CREATE TABLE `PROPERTY` (
    `id` int(11) NOT NULL,
    `key` varchar(64) NOT NULL,
    `value` text NOT NULL,
    PRIMARY KEY (`id`,`key`)
  );
  </code></pre>
  
  <p>I need to get all ids that have MULTIPLE specific key-value entries. For example, all ids that have keys "foo", "bar", and "foobar".</p>