Skip to content

Instantly share code, notes, and snippets.

@pcothenet

pcothenet/events_email.md

Last active August 29, 2015 14:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pcothenet/27f8e0bdbb4fa76a2943 to your computer and use it in GitHub Desktop.
Save pcothenet/27f8e0bdbb4fa76a2943 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
events_email.md 
SELECT
		e.event_id,
		e.event_timestamp,
		e.event,
		c.contact_id,
		c.email
FROM 
		events AS e
LEFT JOIN 
		contacts AS c 
ON 
		e.contact_id = c.contact_id
LIMIT 1000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment