Skip to content

Instantly share code, notes, and snippets.

@flashvnn

flashvnn/flush_email_queue_recipients.sql

Forked from Nolwennig/flush_email_queue_recipients.sql
Created July 18, 2017 03:02
Show Gist options
  • Save flashvnn/80c565846f341b9b5136bc6cdfbd2288 to your computer and use it in GitHub Desktop.
Save flashvnn/80c565846f341b9b5136bc6cdfbd2288 to your computer and use it in GitHub Desktop.
Download ZIP
Magento flush email queue recipients
Raw
flush_email_queue_recipients.sql
DELETE
FROM `core_email_queue_recipients`
WHERE `core_email_queue_recipients`.`message_id` NOT IN
(
SELECT `core_email_queue`.`message_id`
FROM `core_email_queue`
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment