Skip to content

Instantly share code, notes, and snippets.

@Tomasz-Silpion

Tomasz-Silpion/recipients.sql

Created October 30, 2017 16:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Tomasz-Silpion/7ab098970bafd4e297e496ee5c1a1e83 to your computer and use it in GitHub Desktop.
Save Tomasz-Silpion/7ab098970bafd4e297e496ee5c1a1e83 to your computer and use it in GitHub Desktop.
Download ZIP
Get Magento queue recipients who received outdated email
Raw
recipients.sql
SELECT DISTINCT `recipient_email` FROM `core_email_queue` INNER JOIN `core_email_queue_recipients` ON `core_email_queue`.`message_id` = `core_email_queue_recipients`.`message_id` WHERE `processed_at` > '2017-10-30 00:00:00' AND `created_at` < '2017-10-25 00:00:00'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment