title: Magento SQL Query to show product manufacturer
body: <p>I am trying to query the Product Manufacturer in Magento 1.7.0.2 . I browse again and again all the table to where I can get the manufacturer table and connect it with product SKU.</p>
  
  <p>I try this query to hope that I can get the manufacturers of the product:</p>
  
  <pre><code>SELECT 
  eav_attribute_option_value.value FROM 
  eav_attribute,
  eav_attribute_option,
  eav_attribute_option_value 
  WHERE 
  eav_attribute.attribute_code = 'manufacturer' AND
  eav_attribute_option.attribute_id = eav_attribute.attribute_id AND
  eav_attribute_option_value.option_id = eav_attribute_option.option_id
  </code></pre>
  
  <p>but it is not equal to the product manufacturer when I compare the result to my magento admin product manufacturer.</p>
  
  <p>My question is that what should I do to query so that I can get the list of manufacturers of the product so that I can <code>sql join</code> in with <code>catalog_product_enity</code>'s <code>SKU</code>.</p>
  
  <p>Does anyone has an idea about my case? I am new with magento so please be gentle with me.
  Any help will be appreciated, Thanks in advance</p>