I’ve been following the chain of threads, and thought I’d add that some trigger to be able to unsubscribe users would be great! Your plugin is pretty much exactly what I’ve been needing, but I’m not able to make it live until I have a way for users to opt-out and unsubscribe manually somehow.
I only ran the query once, from the menu in the dev database. I’ve been testing more and it isn’t specific to that query either. It’s like the databases are linked or something.