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