vegangirlthatcodes
3/11/2018 - 8:11 PM

Select subscriber with completed orders

Select customers with completed orders that have subscribed to out newsletter. (Magento)

select-subscribers-with-orders
content_copyfile_download
SELECT subscriber_email FROM newsletter_subscriber
WHERE subscriber_email IN (SELECT DISTINCT customer_email from sales_order WHERE status = "complete");