replace into `customer_entity_int` (`entity_type_id`,`attribute_id`,`entity_id`,`value`) SELECT 1 `entity_type_id`,254 attribute_id, c.entity_id, IF( ISNULL( cc.value ) , 0, 1 ) value FROM `customer_entity` c LEFT JOIN `customer_entity_varchar` cc ON cc.entity_id = c.entity_id AND cc.attribute_id =16 LIMIT 100