jwohlfeil · February 14, 2017 12:40
diff --git a/Mage - Update all subscribers into a customer group (e.g. 5).sql b/Mage - Update all subscribers into a customer group (e.g. 5).sql
 UPDATE
    customer_entity,
    newsletter_subscriber
 SET
    customer_entity.`group_id` = 5
 WHERE
    customer_entity.`entity_id` = newsletter_subscriber.`customer_id`
 AND
    newsletter_subscriber.`subscriber_status` = 1;
	UPDATE
	customer_entity,
	newsletter_subscriber
	SET
	customer_entity.`group_id` = 5
	WHERE
	customer_entity.`entity_id` = newsletter_subscriber.`customer_id`
	AND
	newsletter_subscriber.`subscriber_status` = 1;