Hi all, i have a general query run to get my subscribers from the database as follows;
select
cscart_subscribers.subscriber_id,
cscart_subscribers.email
from
cscart_subscribers,
cscart_user_mailing_lists
where
cscart_subscribers.subscriber_id = cscart_user_mailing_lists.subscriber_id and
cscart_user_mailing_lists.list_id = 1 and
cscart_user_mailing_lists.confirmed = 1;
This time, I am wanting to limit my newsletter to recipients in two countries. My query below is working, but it seems to be grabbing each email address multiple times for some reason. Can anyone help with the logic of my query? Many thanks.
select
cscart_subscribers.subscriber_id,
cscart_subscribers.email,
cscart_countries.region
from
cscart_subscribers,
cscart_user_mailing_lists,
cscart_countries
where
cscart_subscribers.subscriber_id = cscart_user_mailing_lists.subscriber_id and
cscart_user_mailing_lists.list_id = 1 and
cscart_user_mailing_lists.confirmed = 1 and
cscart_countries.region = 'AU' or
cscart_countries.region = 'NZ';