Email addresses filtered by names



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

Subscribers with *gmail* addresses

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 (Lists."Name" = 'Clients Newsletter' AND ListMembers."Status" IN ('Subscribed') AND ListMembers."Email" LIKE '%gmail%')
ORDER BY ListMembers."Email"

Open Query