Magento - Grab Customer first and last name raw sql

get-customer-names.sql

SELECT `e`.*, 
       `at_prefix`.`value` 
       AS `prefix`, 
       `at_firstname`.`value` 
       AS `firstname`, 
       `at_middlename`.`value` 
       AS `middlename`, 
       `at_lastname`.`value` 
       AS `lastname`, 
       `at_suffix`.`value` 
       AS `suffix`, 
       Concat(IF(at_prefix.value IS NOT NULL 
                 AND at_prefix.value != '', 
              Concat(Ltrim(Rtrim(at_prefix.value)), ' '), 
              ''), Ltrim(Rtrim(at_firstname.value)), ' ', IF( 
       at_middlename.value IS NOT NULL 
       AND 
       at_middlename.value != '', Concat(Ltrim(Rtrim(at_middlename.value)), ' ') 
                                                          , ''), 
       Ltrim(Rtrim(at_lastname.value)), IF(at_suffix.value IS NOT NULL 
       AND at_suffix.value != '', Concat(' ', Ltrim(Rtrim(at_suffix.value))), '' 
                                        )) AS 
       `name` 
FROM   `customer_entity` AS `e` 
       LEFT JOIN `customer_entity_varchar` AS `at_prefix` 
              ON ( `at_prefix`.`entity_id` = `e`.`entity_id` ) 
                 AND ( `at_prefix`.`attribute_id` = '4' ) 
       LEFT JOIN `customer_entity_varchar` AS `at_firstname` 
              ON ( `at_firstname`.`entity_id` = `e`.`entity_id` ) 
                 AND ( `at_firstname`.`attribute_id` = '5' ) 
       LEFT JOIN `customer_entity_varchar` AS `at_middlename` 
              ON ( `at_middlename`.`entity_id` = `e`.`entity_id` ) 
                 AND ( `at_middlename`.`attribute_id` = '6' ) 
       LEFT JOIN `customer_entity_varchar` AS `at_lastname` 
              ON ( `at_lastname`.`entity_id` = `e`.`entity_id` ) 
                 AND ( `at_lastname`.`attribute_id` = '7' ) 
       LEFT JOIN `customer_entity_varchar` AS `at_suffix` 
              ON ( `at_suffix`.`entity_id` = `e`.`entity_id` ) 
                 AND ( `at_suffix`.`attribute_id` = '8' ) 
WHERE  ( `e`.`entity_type_id` = '1' )