Gossamer Forum
Home : Products : Gossamer List : Discussion :

SQL for removing bounced subscribers

Quote Reply
SQL for removing bounced subscribers
The web-based interface isn't really ready to scale. I'm running a company newsletter with 60,000+ subscribers and because the import was not from a validated email database there are many thousands of invalid emails.

The web based interface for removing bounced subscribers is a bit awkward, I have upwards of 300 pages to go through and each time I remove a page of subscribers it sends me back to a list of all subscribers (not just the bounced ones).

Can someone post some SQL that allows mass deletion based on a minimum bounce criteria?

e.g. if bounced (or whatever the column is, I haven't checked) > 2

cdkrg

Able2Know :: Ajooja Directory
Quote Reply
Re: [cdkrg] SQL for removing bounced subscribers In reply to
Hi,

A new feature of removing bounced subscribers will be added in the next release. You can use the SQL below to delete bounced emails:

DELETE FROM glist_Subscribers where sub_bounced > 0 and sub_bounced <=n

TheStone.

B.