Skip to content

Instantly share code, notes, and snippets.

@djerraballi
Created July 18, 2015 23:35
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 djerraballi/6ad64b649abb198b5ebe to your computer and use it in GitHub Desktop.
Save djerraballi/6ad64b649abb198b5ebe to your computer and use it in GitHub Desktop.
SELECT 'model.User' AS NUCLEUS_TYPE,A0.firstName,A0.id,A0.lastName FROM `User` A0 WHERE A0.id IN(290)
SELECT 'model.UserEmail' AS NUCLEUS_TYPE,A0.email,A0.`primary`,A0.userId FROM UserEmail A0 WHERE EXISTS (SELECT 'model.User' AS NUCLEUS_TYPE,A0_SUB.id AS DN_APPID FROM `User` A0_SUB WHERE A0_SUB.id IN(290) AND A0.userId = A0_SUB.id)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment