SELECT 0 orders_id,
c.increment_id customers_id, 
concat(sfqa.firstname, ' ', sfqa.lastname) customers_name,
ifnull(sfqa.company,'n/a')  customers_company, 
sfqa.street customers_street_address, 
sfqa.region customers_suburb, 
sfqa.city customers_city, 
sfqa.postcode customers_postcode, 
sfqa.region customers_state, 
(case when sfqa.country_id = "NL" then "Nederland" 
when "BE" then "Belgie" end) customers_country, 
sfqa.postcode customers_telephone, 
sfqa.email customers_email_address, 
0 customers_address_format_id, 
'' delivery_name, 
'' delivery_company, 
'' delivery_street_address, 
'' delivery_suburb, 
'' delivery_city, 
'' delivery_postcode, 
'' delivery_state, 
'' delivery_country, 
'' delivery_address_format_id, 
'' billing_name, 
'' billing_company, 
'' billing_street_address, 
'' billing_suburb, 
'' billing_city, 
'' billing_postcode, 
'' billing_state, 
'' billing_country, 
0 billing_address_format_id, 
'' payment_method, 
'' cc_type, 
'' cc_owner, 
'' cc_number, 
'' cc_expires, 
min(sfqa.created_at) last_modified, 
null  date_purchased, 
0 orders_status, 
null orders_date_finished, 
'' currency, 
'' currency_value

from 
customer_entity c join
sales_flat_quote_address sfqa

where 
c.entity_id = sfqa.customer_id
group by c.entity_id