I've always been a bit quesy about our suppression list logic & just want to sanity check it
The suppression list is
- all emails in log_civicrm_email where
- the email is not in silverpop_export_staging OR
- the record is more recent than the latest in silverpop_export_staging
- the email is not in silverpop_export_staging OR
silverpop_export_staging holds all primary email addresses from non-deleted contacts
This leaves the situation where a contact has more than one email. My understanding is that the non-primary will wind up on the suppression list - which is OK until it becomes primary but I don't think it will come OFF the suppression list if it does.
I have a feeling this might have come up before & been determined to be 'OK' due to the low volume & the annual-ish purge of the MSL