Deleting recipients in the database

[bla2508]

Hi i have a new question.

I want to delete all recipient off a mailinglist but in the documentation is only the option to delete recipients over the targetgroup.
But i have no target groups

When i delete only one recipient i only remove the dependency off the mailinglists and not the recipient in the database.

Now i search a mysql query to delete the recipients restless in the database but i only want to delete the recipients off one mailinglist.

Thanks for your help.

[joris1]

Something like :

Code: Select all

delete FROM customer_1_tbl where customer_id not in (select customer_id from customer_1_binding_tbl);