title: Get customer names and emails from magento database
body: <p>I am trying to get all names and emails from our customers in magento.</p>
  
  <p>I have the following code, but I am not sure how to get the email</p>
  
  <pre><code>SELECT entity_id, GROUP_CONCAT( VALUE
  SEPARATOR  ' ' ) AS fullname
  FROM customer_address_entity_varchar AS val
  INNER JOIN eav_attribute AS attr ON attr.attribute_id = val.attribute_id
  WHERE attr.attribute_code
  IN (
  'firstname',  'lastname',  'email'
  )
  GROUP BY entity_id
  LIMIT 0 , 30
  </code></pre>