title: Get rows with matching values in column in same table
body: <p>I have the following DDLs...</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `product` (
    `id_product` int(10),
    `id_manufacturer` int(10)
    );
  
  
  INSERT INTO `product` (`id_product`, `id_manufacturer`) VALUES
  (1,1),
  (2,1),
  (3,2),
  (4,1),
  (5,2);
  
  CREATE TABLE IF NOT EXISTS `feature_product` (
    `id_feature` int(10),
    `id_product` int(10),
    `id_feature_value` int(10)
  );
  
  
  INSERT INTO `feature_product` (`id_feature`, `id_product`, `id_feature_value`) VALUES
  (5, 1, 9),
  (5, 2, 9),
  (5, 3, 10),
  (5, 4, 10),
  (7, 5, 10);
  </code></pre>
  
  <p><a href="http://sqlfiddle.com/#!2/cbe05/1/0" rel="nofollow">http://sqlfiddle.com/#!2/cbe05/1/0</a></p>
  
  <p>Can you explain me please, how I can get - all Products with the same Manufacturer and the same Feature_value?</p>
  
  <p>Now (in project) I do it with 2 additional SELECT's (for getting id_manufacturer and id_feature_value), but maybe there are more correct (and fast) way?</p>
  
  <p>Thanks for your time and sorry for my English)</p>
  
  <p>I need too see result like this:</p>
  
  <pre><code>id_product | 
  -----------|
  1          |
  2          |
  </code></pre>
  
  <p>only this 2 products have same manufacturer and (at the same time) same feature value </p>