Helpful SQL Search Examples

[adrianjean]

Context:

• The documentation for advanced SQL searches is good, but could use more helpful examples to make it easier for folks to get more use out of this awesome feature.
• This issue could be a running collection of people's SQL searches that can help others, and maybe also added to the official docs

Helpful SQL searches:

• Find all those who have unsubscribed from a certain list. Replace [LIST_ID] with the ID of your list:

  EXISTS (SELECT 1 FROM subscriber_lists WHERE subscriber_lists.subscriber_id = subscribers.id AND subscriber_lists.list_id = [LIST_ID] AND subscriber_lists.status = 'unsubscribed')