SQL query to get all addresses associated with customer in Magento
<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>