Email Marketing Software for your Mailing Lists - Re:Subscribers that unsubscribed from a list

mb1234
User

Fresh Boarder

Posts: 1

Karma: 0

Subscribers that unsubscribed from a list - 2008/02/18 19:13 Hi,
please help.
Which database table / field contains the information, that a subscriber unsubscribed from a specific list?
I searched all acajoom tables but couldn't find it.

Thanks in advance for your help,
Michael

| | To post on the forum you need to sign in.

Adrien
Admin

Admin

Posts: 1555

Karma: 47

Re:Subscribers that unsubscribed from a list - 2008/02/18 20:16 If a user is not subscribed to any list, that means he unsubscribed from all your Mailing lists.
The queue table contains the information about who subscribed to which Mailing list so with a query you will be able to have a list of all your unsubscribed users.

Code:


 SELECT S.* FROM jos_acajoom_subscribers as S LEFT JOIN jos_acajoom_queue as Q ON Q.subscriber_id = S.id WHERE Q.subscriber_id IS NULL

I didn't test the query and directly wrote it but that should be something like that. Please check our official documentation and existing replies before posting on our forum!

Best Regards,
Adrien

| | To post on the forum you need to sign in.