title: Get customer names, emails and phone numbers from Magento 1.9 database
body: <p>I have two different SQL codes, one to get user names and emails, and the other one just phone numbers.</p>
  <p>Can you help to combine it with one script so it will be possible to get a list of user names, emails, and phone numbers?</p>
  <p>Here is the query to get User names and Emails (by @Steve Robbins):</p>
  <pre><code>select ce.entity_id, concat(cevf.value, ' ', cevl.value) fullname, ce.email
  from customer_entity ce
  inner join customer_entity_varchar cevf
      on ce.entity_id = cevf.entity_id
  inner join eav_attribute eaf
      on eaf.attribute_id = cevf.attribute_id
  inner join customer_entity_varchar cevl
      on ce.entity_id = cevl.entity_id
  inner join eav_attribute eal
      on eal.attribute_id = cevl.attribute_id
  inner join eav_entity_type eet
      on eet.entity_type_id = eal.entity_type_id = eaf.entity_type_id
  where
      eet.entity_type_code = 'customer'
      and eaf.attribute_code = 'firstname'
      and eal.attribute_code = 'lastname'
  order by ce.entity_id
  </code></pre>
  <p>And this one for phone numbers only (by @zaka47):</p>
  <pre><code>select customer_address_entity_varchar.value from customer_address_entity_varchar
  left join  customer_entity on customer_entity.entity_id = &quot;your_customer_id&quot;
  left join  customer_address_entity on customer_address_entity.parent_id = customer_entity.entity_id
  join eav_attribute on eav_attribute.attribute_code=&quot;telephone&quot;
  where customer_address_entity_varchar.attribute_id = eav_attribute.attribute_id
  </code></pre>
  <p>My goal is to get the following table structure:</p>
  <pre><code>------------------------------------------------------
  Full Name  |   Email Address     | Phone Number 
  ------------------------------------------------------
  David Ros  |   david@email.com   | 02-30493929  
  Joe Pratt  |   joe@email.com     | 03-20392030   
  ------------------------------------------------------
  </code></pre>
  <p>Thanks.</p>