I'm trying to update segments in MailChimp and I'm not sure how to get this info out of Magento. Is there an easy way to export a list of customer email addresses that:
A) purchased a specific SKU or series of SKUs that begin with XYZ
B) are subscribed to the store's newsletter?
I'm guessing there's probably a simple SQL statement that can do this-- but don't know enough about the Magento 1.9 database structure to do it. Any assistance would be greatly appreciated!