Skip to content

Instantly share code, notes, and snippets.

@cirpo
Created March 1, 2011 09:15
Show Gist options
  • Select an option

  • Save cirpo/848876 to your computer and use it in GitHub Desktop.

Select an option

Save cirpo/848876 to your computer and use it in GitHub Desktop.
SELECT
se.id as id,
email.value as email,
tessera.value as tessera
FROM
sym_entries se
LEFT JOIN sym_entries_data_119 email
ON
se.id = email.entry_id
LEFT JOIN sym_entries_data_121 tessera
ON
se.id = tessera.entry_id
GROUP BY email.value
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment