Reading Time: < 1 minute
Simply create a trigger which will insert unsubscribed users in the blacklist after every update on the subscriber table.
(emailaddress, list, bandate)
SELECT emailaddress, ‘g’, UNIX_TIMESTAMP( )
FROM iem_list_subscribers
WHERE unsubscribed != ‘0’;
SELECT emailaddress, ‘g’, UNIX_TIMESTAMP( )
FROM iem_list_subscribers
WHERE unsubscribed != ‘0’;