How to list the orders received by Magento 1 from MailChimp campaings?

[dmitry_fedyuk (Dmitrii Fediuk)]

SELECT entity_id,  increment_id, created_at, mailchimp_campaign_id, customer_firstname, customer_lastname, customer_email
FROM sales_flat_order
WHERE 0 <> mailchimp_abandonedcart_flag OR mailchimp_campaign_id IS NOT NULL
ORDER BY created_at DESC;