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';