Skip to content

Instantly share code, notes, and snippets.

@Kristjan-Reinsberg

Kristjan-Reinsberg/gist:d3dab52258ff42a2345fab460cbb8619

Created June 5, 2020 17:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Kristjan-Reinsberg/d3dab52258ff42a2345fab460cbb8619 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Kristjan-Reinsberg/d3dab52258ff42a2345fab460cbb8619 to your computer and use it in GitHub Desktop.
Download ZIP
SQL until first occurance
Raw
gistfile1.txt
SELECT DISTINCT
clients.papers_email_address,
LEFT(clients.name , LOCATE(' ',clients.name) - 1) AS eesnimi_tyhikuni /* MARI TAMM -> MARI (täisnime hoitakse)*/
FROM
policies
LEFT JOIN clients ON clients.id = policies.client_id
WHERE
policies.end_date > '2020-06-08'
AND clients.papers_email_address IS NOT NULL
AND clients.papers_email_address != ''
AND clients.client_codetype_id = 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment