Contents

select
c.entity_id,
c.email,
c.created_at,
c.updated_at,
c.is_active,
c.group_id,
-- fetch columns from customer_entity_varchar
(select f.value from customer_entity_varchar f where c.entity_id = f.entity_id and f.attribute_id = 3) created_in,
(select f.value from customer_entity_varchar f where c.entity_id = f.entity_id and f.attribute_id = 4) prefix,
(select f.value from customer_entity_varchar f where c.entity_id = f.entity_id and f.attribute_id = 5) fitst_name,
(select f.value from customer_entity_varchar f where c.entity_id = f.entity_id and f.attribute_id = 6) middle_name,
(select f.value from customer_entity_varchar f where c.entity_id = f.entity_id and f.attribute_id = 7) last_name,
(select f.value from customer_entity_varchar f where c.entity_id = f.entity_id and f.attribute_id = 8) suffix,
(select f.value from customer_entity_varchar f where c.entity_id = f.entity_id and f.attribute_id = 12) password_hash,
(select f.value from customer_entity_varchar f where c.entity_id = f.entity_id and f.attribute_id = 15) taxvat,
-- fetch columns from customer_entity_int
(select f.value from customer_entity_int f where c.entity_id = f.entity_id and f.attribute_id = 13) default_billing,
(select f.value from customer_entity_int f where c.entity_id = f.entity_id and f.attribute_id = 14) default_shipping,
(select f.value from customer_entity_int f where c.entity_id = f.entity_id and f.attribute_id = 18) gender,
(select f.value from customer_entity_int f where c.entity_id = f.entity_id and f.attribute_id = 149) reward_update_notification,
(select f.value from customer_entity_int f where c.entity_id = f.entity_id and f.attribute_id = 150) reward_warning_notification,
-- fetch columns from customer_entity_datetime
(select f.value from customer_entity_datetime f where c.entity_id = f.entity_id and f.attribute_id = 11) dob

from customer_entity c;

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
workarea-magento_migrator-1.0.1	lib/sql/magento_customer.sql
workarea-magento_migrator-1.0.0.pre	lib/sql/magento_customer.sql