title: SQL query to get all addresses associated with customer in Magento
body: <p>I'm migrating from Magento, and need the mySQL query to get all addresses associated with each customer.</p>
  
  <p>this is how I get the address IDs, but not sure if customer_address_entity.parent_id is a customer id.</p>
  
  <pre><code>select 
      email, group_concat(a.entity_id)
  from
      customer_entity as c
          inner join
      customer_address_entity as a ON a.parent_id = c.entity_id
  group by email
  </code></pre>
  
  <p>My Magento DB dump is from Magento 1.6.x</p>
  
  <p>Can you propose a query for it?</p>