Skip to content

Instantly share code, notes, and snippets.

@oreales

oreales/buyers-subscribers-emails

Last active August 29, 2015 14:25
Show Gist options
  • Save oreales/339424c0419e634dc21c to your computer and use it in GitHub Desktop.
Save oreales/339424c0419e634dc21c to your computer and use it in GitHub Desktop.
Download ZIP
Magento: Sacar emails de subscriptores y compradores de un store view
Raw
buyers-subscribers-emails
SET @storeId = 10;
(SELECT subscriber_email as email FROM newsletter_subscriber WHERE store_id = @storeId)
UNION DISTINCT
(SELECT customer_email FROM sales_flat_order WHERE store_id = @storeId);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment