I wonder how to unsubscribe user from only one list, the sql way.
Maybe there is an other an easier way to do it, please let me know.
I tried :
delete from phplist_listuser lu
inner join phplist_user_user uu on lu.userid=uu.id
and lu.userid in
select id from phplist_user_user uu
where uu.email in
... emails ...
order by uu.email;
but this request does not unsubscribe the users.
Thanks by advance