'Subscribed' email addresses



MailChimp is a cloud-based email marketing solution, that allows designing and sending marketing emails.

These addresses are ready to receive email

Query Text

SELECT ListMembers."ListId", Lists."Name", ListMembers."Email", ListMembers."First Name", ListMembers."Last Name", ListMembers."CreatedDate", ListMembers."LastUpdate"
  FROM "ListMembers"
INNER JOIN Lists ON ListMembers."ListId" = Lists."Id"
WHERE (ListMembers."Status" IN ('Subscribed'))
ORDER BY Lists."Name", ListMembers."Email"

Open Query