1 2 |
# mid ist die id des newsletters SELECT email FROM sys_dmail_maillog WHERE return_code <> 0 AND mid = 95 AND return_code != 551; |
1 2 3 |
# mid ist die id des newsletters UPDATE `tx_isbdb_persons` SET tx_isbdb_persons.email ='' WHERE email LIKE '%@%' and EXISTS ( SELECT email FROM sys_dmail_maillog WHERE return_code <> 0 AND mid = 95 AND return_code != 551 and sys_dmail_maillog.email = tx_isbdb_persons.email) |