title: How to pull all the product id, skus, product names, description in magento using only mysql?
body: <p>How i will pull all the prduct ir, skus , product name (titles) and desxription using mysql from Magento database? I used following query and got all the attributes except product names.</p>
  
  <pre><code>SELECT e.entity_id, e.sku, eav.value AS 'description'
  FROM catalog_product_entity e
  JOIN catalog_product_entity_text eav
    ON e.entity_id = eav.entity_id
  JOIN eav_attribute ea
    ON eav.attribute_id = ea.attribute_id
  WHERE ea.attribute_code = 'description'
  </code></pre>