Skip to content

Instantly share code, notes, and snippets.

@colinhacks

colinhacks/gist:3c5c46e6934720a5f4dae16d01dbe6da

Created March 20, 2019 16:40
Show Gist options
  • Save colinhacks/3c5c46e6934720a5f4dae16d01dbe6da to your computer and use it in GitHub Desktop.
Save colinhacks/3c5c46e6934720a5f4dae16d01dbe6da to your computer and use it in GitHub Desktop.
Download ZIP
Generated TypeORM query with nested relations
Raw
gistfile1.txt
SELECT DISTINCT "distinctAlias"."user_id" AS "ids_User_id"
FROM (SELECT "user"."id" AS
"User_id",
"user"."createdat" AS
"User_createdAt",
"user"."updatedat" AS
"User_updatedAt",
"user"."authid" AS
"User_authId",
"user"."firstname" AS
"User_firstName",
"user"."middlename" AS
"User_middleName",
"user"."lastname" AS
"User_lastName",
"user"."maidenname" AS
"User_maidenName",
"user"."nickname" AS
"User_nickname",
"user"."prefix" AS
"User_prefix",
"user"."suffix" AS
"User_suffix",
"user"."dob" AS
"User_dob",
"user"."npi" AS
"User_npi",
"user"."ssn" AS
"User_ssn",
"user"."gender" AS
"User_gender",
"user"."genderidentity" AS
"User_genderIdentity",
"user"."picture" AS
"User_picture",
"user"."nonsecureconsent" AS
"User_nonSecureConsent",
"user"."termsconsent" AS
"User_termsConsent",
"user"."email" AS
"User_email"
,
"user"."homephone"
AS "User_homePhone",
"user"."workphone" AS
"User_workPhone",
"user"."cellphone" AS
"User_cellPhone",
"user"."profession" AS
"User_profession",
"user"."maritalstatus" AS
"User_maritalStatus",
"user"."exercise" AS
"User_exercise",
"user"."exercisedetails" AS
"User_exerciseDetails",
"user"."diet" AS
"User_diet",
"user"."smoking" AS
"User_smoking",
"user"."smokingstartyear" AS
"User_smokingStartYear",
"user"."smokingquityear" AS
"User_smokingQuitYear",
"user"."packsperday" AS
"User_packsPerDay",
"user"."smokingdetails" AS
"User_smokingDetails",
"user"."caffeineintake" AS
"User_caffeineIntake",
"user"."caffeineintakedetails" AS
"User_caffeineIntakeDetails",
"user"."alcoholintake" AS
"User_alcoholIntake",
"user"."alcoholintakedetails" AS
"User_alcoholIntakeDetails",
"user"."recreationaldrugs" AS
"User_recreationalDrugs",
"user"."drugusedetails" AS
"User_drugUseDetails",
"user"."sexuallyactive" AS
"User_sexuallyActive",
"user"."sexualpartnergenders" AS
"User_sexualPartnerGenders",
"user"."sexualactivitydetails" AS
"User_sexualActivityDetails",
"user"."profile" AS
"User_profile",
"user"."addressid" AS
"User_addressId",
"user"."shippingaddressid" AS
"User_shippingAddressId",
"user"."practiceid" AS
"User_practiceId",
"User__address"."id" AS
"User__address_id",
"User__address"."createdat" AS
"User__address_createdAt",
"User__address"."updatedat" AS
"User__address_updatedAt",
"User__address"."line1" AS
"User__address_line1",
"User__address"."line2" AS
"User__address_line2",
"User__address"."city" AS
"User__address_city",
"User__address"."region" AS
"User__address_region",
"User__address"."postal" AS
"User__address_postal",
"User__address"."country" AS
"User__address_country",
"User__address"."practiceid" AS
"User__address_practiceId",
"User__shippingAddress"."id" AS
"User__shippingAddress_id",
"User__shippingAddress"."createdat" AS
"User__shippingAddress_createdAt",
"User__shippingAddress"."updatedat" AS
"User__shippingAddress_updatedAt",
"User__shippingAddress"."line1" AS
"User__shippingAddress_line1",
"User__shippingAddress"."line2" AS
"User__shippingAddress_line2",
"User__shippingAddress"."city" AS
"User__shippingAddress_city",
"User__shippingAddress"."region" AS
"User__shippingAddress_region",
"User__shippingAddress"."postal" AS
"User__shippingAddress_postal",
"User__shippingAddress"."country" AS
"User__shippingAddress_country",
"User__shippingAddress"."practiceid" AS
"User__shippingAddress_practiceId",
"User__practice"."id" AS
"User__practice_id",
"User__practice"."createdat" AS
"User__practice_createdAt",
"User__practice"."updatedat" AS
"User__practice_updatedAt",
"User__practice"."name" AS
"User__practice_name",
"User__practice"."adminemail" AS
"User__practice_adminEmail",
"User__practice"."phone" AS
"User__practice_phone",
"User__practice"."parentid" AS
"User__practice_parentId",
"User__allergies"."id" AS
"User__allergies_id",
"User__allergies"."createdat" AS
"User__allergies_createdAt",
"User__allergies"."updatedat" AS
"User__allergies_updatedAt",
"User__allergies"."kind" AS
"User__allergies_kind",
"User__allergies"."allergen" AS
"User__allergies_allergen",
"User__allergies"."severity" AS
"User__allergies_severity",
"User__allergies"."anaphylaxis" AS
"User__allergies_anaphylaxis",
"User__allergies"."details" AS
"User__allergies_details",
"User__allergies"."userid" AS
"User__allergies_userId",
"User__problems"."id" AS
"User__problems_id",
"User__problems"."createdat" AS
"User__problems_createdAt",
"User__problems"."updatedat" AS
"User__problems_updatedAt",
"User__problems"."details" AS
"User__problems_details",
"User__problems"."icdcode" AS
"User__problems_icdCode",
"User__problems"."userid" AS
"User__problems_userId",
"User__problems__icd"."code" AS
"User__problems__icd_code",
"User__problems__icd"."name" AS
"User__problems__icd_name",
"User__problems__icd"."longname" AS
"User__problems__icd_longname",
"User__vaccines"."id" AS
"User__vaccines_id",
"User__vaccines"."createdat" AS
"User__vaccines_createdAt",
"User__vaccines"."updatedat" AS
"User__vaccines_updatedAt",
"User__vaccines"."type" AS
"User__vaccines_type",
"User__vaccines"."date" AS
"User__vaccines_date",
"User__vaccines"."route" AS
"User__vaccines_route",
"User__vaccines"."site" AS
"User__vaccines_site",
"User__vaccines"."lot" AS
"User__vaccines_lot",
"User__vaccines"."manufacturer" AS
"User__vaccines_manufacturer",
"User__vaccines"."details" AS
"User__vaccines_details",
"User__vaccines"."userid" AS
"User__vaccines_userId",
"User__toRelationships"."id" AS
"User__toRelationships_id",
"User__toRelationships"."createdat" AS
"User__toRelationships_createdAt",
"User__toRelationships"."updatedat" AS
"User__toRelationships_updatedAt",
"User__toRelationships"."relation" AS
"User__toRelationships_relation",
"User__toRelationships"."user1id" AS
"User__toRelationships_user1Id",
"User__toRelationships"."user2id" AS
"User__toRelationships_user2Id",
"User__toRelationships__user1"."id" AS
"User__toRelationships__user1_id",
"User__toRelationships__user1"."createdat" AS
"User__toRelationships__user1_createdAt",
"User__toRelationships__user1"."updatedat" AS
"User__toRelationships__user1_updatedAt",
"User__toRelationships__user1"."authid" AS
"User__toRelationships__user1_authId",
"User__toRelationships__user1"."firstname" AS
"User__toRelationships__user1_firstName",
"User__toRelationships__user1"."middlename" AS
"User__toRelationships__user1_middleName",
"User__toRelationships__user1"."lastname" AS
"User__toRelationships__user1_lastName",
"User__toRelationships__user1"."maidenname" AS
"User__toRelationships__user1_maidenName",
"User__toRelationships__user1"."nickname" AS
"User__toRelationships__user1_nickname",
"User__toRelationships__user1"."prefix" AS
"User__toRelationships__user1_prefix",
"User__toRelationships__user1"."suffix" AS
"User__toRelationships__user1_suffix",
"User__toRelationships__user1"."dob" AS
"User__toRelationships__user1_dob",
"User__toRelationships__user1"."npi" AS
"User__toRelationships__user1_npi",
"User__toRelationships__user1"."ssn" AS
"User__toRelationships__user1_ssn",
"User__toRelationships__user1"."gender" AS
"User__toRelationships__user1_gender",
"User__toRelationships__user1"."genderidentity" AS
"User__toRelationships__user1_genderIdentity",
"User__toRelationships__user1"."picture" AS
"User__toRelationships__user1_picture",
"User__toRelationships__user1"."nonsecureconsent" AS
"User__toRelationships__user1_nonSecureConsent",
"User__toRelationships__user1"."termsconsent" AS
"User__toRelationships__user1_termsConsent",
"User__toRelationships__user1"."email" AS
"User__toRelationships__user1_email",
"User__toRelationships__user1"."homephone" AS
"User__toRelationships__user1_homePhone",
"User__toRelationships__user1"."workphone" AS
"User__toRelationships__user1_workPhone",
"User__toRelationships__user1"."cellphone" AS
"User__toRelationships__user1_cellPhone",
"User__toRelationships__user1"."profession" AS
"User__toRelationships__user1_profession",
"User__toRelationships__user1"."maritalstatus" AS
"User__toRelationships__user1_maritalStatus",
"User__toRelationships__user1"."exercise" AS
"User__toRelationships__user1_exercise",
"User__toRelationships__user1"."exercisedetails" AS
"User__toRelationships__user1_exerciseDetails",
"User__toRelationships__user1"."diet" AS
"User__toRelationships__user1_diet",
"User__toRelationships__user1"."smoking" AS
"User__toRelationships__user1_smoking",
"User__toRelationships__user1"."smokingstartyear" AS
"User__toRelationships__user1_smokingStartYear",
"User__toRelationships__user1"."smokingquityear" AS
"User__toRelationships__user1_smokingQuitYear",
"User__toRelationships__user1"."packsperday" AS
"User__toRelationships__user1_packsPerDay",
"User__toRelationships__user1"."smokingdetails" AS
"User__toRelationships__user1_smokingDetails",
"User__toRelationships__user1"."caffeineintake" AS
"User__toRelationships__user1_caffeineIntake",
"User__toRelationships__user1"."caffeineintakedetails" AS
"User__toRelationships__user1_caffeineIntakeDetails",
"User__toRelationships__user1"."alcoholintake" AS
"User__toRelationships__user1_alcoholIntake",
"User__toRelationships__user1"."alcoholintakedetails" AS
"User__toRelationships__user1_alcoholIntakeDetails",
"User__toRelationships__user1"."recreationaldrugs" AS
"User__toRelationships__user1_recreationalDrugs",
"User__toRelationships__user1"."drugusedetails" AS
"User__toRelationships__user1_drugUseDetails",
"User__toRelationships__user1"."sexuallyactive" AS
"User__toRelationships__user1_sexuallyActive",
"User__toRelationships__user1"."sexualpartnergenders" AS
"User__toRelationships__user1_sexualPartnerGenders",
"User__toRelationships__user1"."sexualactivitydetails" AS
"User__toRelationships__user1_sexualActivityDetails",
"User__toRelationships__user1"."profile" AS
"User__toRelationships__user1_profile",
"User__toRelationships__user1"."addressid" AS
"User__toRelationships__user1_addressId",
"User__toRelationships__user1"."shippingaddressid" AS
"User__toRelationships__user1_shippingAddressId",
"User__toRelationships__user1"."practiceid" AS
"User__toRelationships__user1_practiceId",
"User__toRelationships__user2"."id" AS
"User__toRelationships__user2_id",
"User__toRelationships__user2"."createdat" AS
"User__toRelationships__user2_createdAt",
"User__toRelationships__user2"."updatedat" AS
"User__toRelationships__user2_updatedAt",
"User__toRelationships__user2"."authid" AS
"User__toRelationships__user2_authId",
"User__toRelationships__user2"."firstname" AS
"User__toRelationships__user2_firstName",
"User__toRelationships__user2"."middlename" AS
"User__toRelationships__user2_middleName",
"User__toRelationships__user2"."lastname" AS
"User__toRelationships__user2_lastName",
"User__toRelationships__user2"."maidenname" AS
"User__toRelationships__user2_maidenName",
"User__toRelationships__user2"."nickname" AS
"User__toRelationships__user2_nickname",
"User__toRelationships__user2"."prefix" AS
"User__toRelationships__user2_prefix",
"User__toRelationships__user2"."suffix" AS
"User__toRelationships__user2_suffix",
"User__toRelationships__user2"."dob" AS
"User__toRelationships__user2_dob",
"User__toRelationships__user2"."npi" AS
"User__toRelationships__user2_npi",
"User__toRelationships__user2"."ssn" AS
"User__toRelationships__user2_ssn",
"User__toRelationships__user2"."gender" AS
"User__toRelationships__user2_gender",
"User__toRelationships__user2"."genderidentity" AS
"User__toRelationships__user2_genderIdentity",
"User__toRelationships__user2"."picture" AS
"User__toRelationships__user2_picture",
"User__toRelationships__user2"."nonsecureconsent" AS
"User__toRelationships__user2_nonSecureConsent",
"User__toRelationships__user2"."termsconsent" AS
"User__toRelationships__user2_termsConsent",
"User__toRelationships__user2"."email" AS
"User__toRelationships__user2_email",
"User__toRelationships__user2"."homephone" AS
"User__toRelationships__user2_homePhone",
"User__toRelationships__user2"."workphone" AS
"User__toRelationships__user2_workPhone",
"User__toRelationships__user2"."cellphone" AS
"User__toRelationships__user2_cellPhone",
"User__toRelationships__user2"."profession" AS
"User__toRelationships__user2_profession",
"User__toRelationships__user2"."maritalstatus" AS
"User__toRelationships__user2_maritalStatus",
"User__toRelationships__user2"."exercise" AS
"User__toRelationships__user2_exercise",
"User__toRelationships__user2"."exercisedetails" AS
"User__toRelationships__user2_exerciseDetails",
"User__toRelationships__user2"."diet" AS
"User__toRelationships__user2_diet",
"User__toRelationships__user2"."smoking" AS
"User__toRelationships__user2_smoking",
"User__toRelationships__user2"."smokingstartyear" AS
"User__toRelationships__user2_smokingStartYear",
"User__toRelationships__user2"."smokingquityear" AS
"User__toRelationships__user2_smokingQuitYear",
"User__toRelationships__user2"."packsperday" AS
"User__toRelationships__user2_packsPerDay",
"User__toRelationships__user2"."smokingdetails" AS
"User__toRelationships__user2_smokingDetails",
"User__toRelationships__user2"."caffeineintake" AS
"User__toRelationships__user2_caffeineIntake",
"User__toRelationships__user2"."caffeineintakedetails" AS
"User__toRelationships__user2_caffeineIntakeDetails",
"User__toRelationships__user2"."alcoholintake" AS
"User__toRelationships__user2_alcoholIntake",
"User__toRelationships__user2"."alcoholintakedetails" AS
"User__toRelationships__user2_alcoholIntakeDetails",
"User__toRelationships__user2"."recreationaldrugs" AS
"User__toRelationships__user2_recreationalDrugs",
"User__toRelationships__user2"."drugusedetails" AS
"User__toRelationships__user2_drugUseDetails",
"User__toRelationships__user2"."sexuallyactive" AS
"User__toRelationships__user2_sexuallyActive",
"User__toRelationships__user2"."sexualpartnergenders" AS
"User__toRelationships__user2_sexualPartnerGenders",
"User__toRelationships__user2"."sexualactivitydetails" AS
"User__toRelationships__user2_sexualActivityDetails",
"User__toRelationships__user2"."profile" AS
"User__toRelationships__user2_profile",
"User__toRelationships__user2"."addressid" AS
"User__toRelationships__user2_addressId",
"User__toRelationships__user2"."shippingaddressid" AS
"User__toRelationships__user2_shippingAddressId",
"User__toRelationships__user2"."practiceid" AS
"User__toRelationships__user2_practiceId",
"User__fromRelationships"."id" AS
"User__fromRelationships_id",
"User__fromRelationships"."createdat" AS
"User__fromRelationships_createdAt",
"User__fromRelationships"."updatedat" AS
"User__fromRelationships_updatedAt",
"User__fromRelationships"."relation" AS
"User__fromRelationships_relation",
"User__fromRelationships"."user1id" AS
"User__fromRelationships_user1Id",
"User__fromRelationships"."user2id" AS
"User__fromRelationships_user2Id",
"User__fromRelationships__user1"."id" AS
"User__fromRelationships__user1_id",
"User__fromRelationships__user1"."createdat" AS
"User__fromRelationships__user1_createdAt",
"User__fromRelationships__user1"."updatedat" AS
"User__fromRelationships__user1_updatedAt",
"User__fromRelationships__user1"."authid" AS
"User__fromRelationships__user1_authId",
"User__fromRelationships__user1"."firstname" AS
"User__fromRelationships__user1_firstName",
"User__fromRelationships__user1"."middlename" AS
"User__fromRelationships__user1_middleName",
"User__fromRelationships__user1"."lastname" AS
"User__fromRelationships__user1_lastName",
"User__fromRelationships__user1"."maidenname" AS
"User__fromRelationships__user1_maidenName",
"User__fromRelationships__user1"."nickname" AS
"User__fromRelationships__user1_nickname",
"User__fromRelationships__user1"."prefix" AS
"User__fromRelationships__user1_prefix",
"User__fromRelationships__user1"."suffix" AS
"User__fromRelationships__user1_suffix",
"User__fromRelationships__user1"."dob" AS
"User__fromRelationships__user1_dob",
"User__fromRelationships__user1"."npi" AS
"User__fromRelationships__user1_npi",
"User__fromRelationships__user1"."ssn" AS
"User__fromRelationships__user1_ssn",
"User__fromRelationships__user1"."gender" AS
"User__fromRelationships__user1_gender",
"User__fromRelationships__user1"."genderidentity" AS
"User__fromRelationships__user1_genderIdentity",
"User__fromRelationships__user1"."picture" AS
"User__fromRelationships__user1_picture",
"User__fromRelationships__user1"."nonsecureconsent" AS
"User__fromRelationships__user1_nonSecureConsent",
"User__fromRelationships__user1"."termsconsent" AS
"User__fromRelationships__user1_termsConsent",
"User__fromRelationships__user1"."email" AS
"User__fromRelationships__user1_email",
"User__fromRelationships__user1"."homephone" AS
"User__fromRelationships__user1_homePhone",
"User__fromRelationships__user1"."workphone" AS
"User__fromRelationships__user1_workPhone",
"User__fromRelationships__user1"."cellphone" AS
"User__fromRelationships__user1_cellPhone",
"User__fromRelationships__user1"."profession" AS
"User__fromRelationships__user1_profession",
"User__fromRelationships__user1"."maritalstatus" AS
"User__fromRelationships__user1_maritalStatus",
"User__fromRelationships__user1"."exercise" AS
"User__fromRelationships__user1_exercise",
"User__fromRelationships__user1"."exercisedetails" AS
"User__fromRelationships__user1_exerciseDetails",
"User__fromRelationships__user1"."diet" AS
"User__fromRelationships__user1_diet",
"User__fromRelationships__user1"."smoking" AS
"User__fromRelationships__user1_smoking",
"User__fromRelationships__user1"."smokingstartyear" AS
"User__fromRelationships__user1_smokingStartYear",
"User__fromRelationships__user1"."smokingquityear" AS
"User__fromRelationships__user1_smokingQuitYear",
"User__fromRelationships__user1"."packsperday" AS
"User__fromRelationships__user1_packsPerDay",
"User__fromRelationships__user1"."smokingdetails" AS
"User__fromRelationships__user1_smokingDetails",
"User__fromRelationships__user1"."caffeineintake" AS
"User__fromRelationships__user1_caffeineIntake",
"User__fromRelationships__user1"."caffeineintakedetails" AS
"User__fromRelationships__user1_caffeineIntakeDetails",
"User__fromRelationships__user1"."alcoholintake" AS
"User__fromRelationships__user1_alcoholIntake",
"User__fromRelationships__user1"."alcoholintakedetails" AS
"User__fromRelationships__user1_alcoholIntakeDetails",
"User__fromRelationships__user1"."recreationaldrugs" AS
"User__fromRelationships__user1_recreationalDrugs",
"User__fromRelationships__user1"."drugusedetails" AS
"User__fromRelationships__user1_drugUseDetails",
"User__fromRelationships__user1"."sexuallyactive" AS
"User__fromRelationships__user1_sexuallyActive",
"User__fromRelationships__user1"."sexualpartnergenders" AS
"User__fromRelationships__user1_sexualPartnerGenders",
"User__fromRelationships__user1"."sexualactivitydetails" AS
"User__fromRelationships__user1_sexualActivityDetails",
"User__fromRelationships__user1"."profile" AS
"User__fromRelationships__user1_profile",
"User__fromRelationships__user1"."addressid" AS
"User__fromRelationships__user1_addressId",
"User__fromRelationships__user1"."shippingaddressid" AS
"User__fromRelationships__user1_shippingAddressId",
"User__fromRelationships__user1"."practiceid" AS
"User__fromRelationships__user1_practiceId",
"User__fromRelationships__user2"."id" AS
"User__fromRelationships__user2_id",
"User__fromRelationships__user2"."createdat" AS
"User__fromRelationships__user2_createdAt",
"User__fromRelationships__user2"."updatedat" AS
"User__fromRelationships__user2_updatedAt",
"User__fromRelationships__user2"."authid" AS
"User__fromRelationships__user2_authId",
"User__fromRelationships__user2"."firstname" AS
"User__fromRelationships__user2_firstName",
"User__fromRelationships__user2"."middlename" AS
"User__fromRelationships__user2_middleName",
"User__fromRelationships__user2"."lastname" AS
"User__fromRelationships__user2_lastName",
"User__fromRelationships__user2"."maidenname" AS
"User__fromRelationships__user2_maidenName",
"User__fromRelationships__user2"."nickname" AS
"User__fromRelationships__user2_nickname",
"User__fromRelationships__user2"."prefix" AS
"User__fromRelationships__user2_prefix",
"User__fromRelationships__user2"."suffix" AS
"User__fromRelationships__user2_suffix",
"User__fromRelationships__user2"."dob" AS
"User__fromRelationships__user2_dob",
"User__fromRelationships__user2"."npi" AS
"User__fromRelationships__user2_npi",
"User__fromRelationships__user2"."ssn" AS
"User__fromRelationships__user2_ssn",
"User__fromRelationships__user2"."gender" AS
"User__fromRelationships__user2_gender",
"User__fromRelationships__user2"."genderidentity" AS
"User__fromRelationships__user2_genderIdentity",
"User__fromRelationships__user2"."picture" AS
"User__fromRelationships__user2_picture",
"User__fromRelationships__user2"."nonsecureconsent" AS
"User__fromRelationships__user2_nonSecureConsent",
"User__fromRelationships__user2"."termsconsent" AS
"User__fromRelationships__user2_termsConsent",
"User__fromRelationships__user2"."email" AS
"User__fromRelationships__user2_email",
"User__fromRelationships__user2"."homephone" AS
"User__fromRelationships__user2_homePhone",
"User__fromRelationships__user2"."workphone" AS
"User__fromRelationships__user2_workPhone",
"User__fromRelationships__user2"."cellphone" AS
"User__fromRelationships__user2_cellPhone",
"User__fromRelationships__user2"."profession" AS
"User__fromRelationships__user2_profession",
"User__fromRelationships__user2"."maritalstatus" AS
"User__fromRelationships__user2_maritalStatus",
"User__fromRelationships__user2"."exercise" AS
"User__fromRelationships__user2_exercise",
"User__fromRelationships__user2"."exercisedetails" AS
"User__fromRelationships__user2_exerciseDetails",
"User__fromRelationships__user2"."diet" AS
"User__fromRelationships__user2_diet",
"User__fromRelationships__user2"."smoking" AS
"User__fromRelationships__user2_smoking",
"User__fromRelationships__user2"."smokingstartyear" AS
"User__fromRelationships__user2_smokingStartYear",
"User__fromRelationships__user2"."smokingquityear" AS
"User__fromRelationships__user2_smokingQuitYear",
"User__fromRelationships__user2"."packsperday" AS
"User__fromRelationships__user2_packsPerDay",
"User__fromRelationships__user2"."smokingdetails" AS
"User__fromRelationships__user2_smokingDetails",
"User__fromRelationships__user2"."caffeineintake" AS
"User__fromRelationships__user2_caffeineIntake",
"User__fromRelationships__user2"."caffeineintakedetails" AS
"User__fromRelationships__user2_caffeineIntakeDetails",
"User__fromRelationships__user2"."alcoholintake" AS
"User__fromRelationships__user2_alcoholIntake",
"User__fromRelationships__user2"."alcoholintakedetails" AS
"User__fromRelationships__user2_alcoholIntakeDetails",
"User__fromRelationships__user2"."recreationaldrugs" AS
"User__fromRelationships__user2_recreationalDrugs",
"User__fromRelationships__user2"."drugusedetails" AS
"User__fromRelationships__user2_drugUseDetails",
"User__fromRelationships__user2"."sexuallyactive" AS
"User__fromRelationships__user2_sexuallyActive",
"User__fromRelationships__user2"."sexualpartnergenders" AS
"User__fromRelationships__user2_sexualPartnerGenders",
"User__fromRelationships__user2"."sexualactivitydetails" AS
"User__fromRelationships__user2_sexualActivityDetails",
"User__fromRelationships__user2"."profile" AS
"User__fromRelationships__user2_profile",
"User__fromRelationships__user2"."addressid" AS
"User__fromRelationships__user2_addressId",
"User__fromRelationships__user2"."shippingaddressid" AS
"User__fromRelationships__user2_shippingAddressId",
"User__fromRelationships__user2"."practiceid" AS
"User__fromRelationships__user2_practiceId"
FROM "user" "User"
LEFT JOIN "address" "User__address"
ON "User__address"."id" = "user"."addressid"
LEFT JOIN "address" "User__shippingAddress"
ON
"User__shippingAddress"."id" = "user"."shippingaddressid"
LEFT JOIN "organization" "User__practice"
ON "User__practice"."id" = "user"."practiceid"
LEFT JOIN "allergy" "User__allergies"
ON "User__allergies"."userid" = "user"."id"
LEFT JOIN "problem" "User__problems"
ON "User__problems"."userid" = "user"."id"
LEFT JOIN "icd10" "User__problems__icd"
ON "User__problems__icd"."code" =
"User__problems"."icdcode"
LEFT JOIN "vaccine" "User__vaccines"
ON "User__vaccines"."userid" = "user"."id"
LEFT JOIN "relationship" "User__toRelationships"
ON "User__toRelationships"."user2id" = "user"."id"
LEFT JOIN "user" "User__toRelationships__user1"
ON "User__toRelationships__user1"."id" =
"User__toRelationships"."user1id"
LEFT JOIN "user" "User__toRelationships__user2"
ON "User__toRelationships__user2"."id" =
"User__toRelationships"."user2id"
LEFT JOIN "relationship" "User__fromRelationships"
ON "User__fromRelationships"."user1id" = "user"."id"
LEFT JOIN "user" "User__fromRelationships__user1"
ON "User__fromRelationships__user1"."id" =
"User__fromRelationships"."user1id"
LEFT JOIN "user" "User__fromRelationships__user2"
ON "User__fromRelationships__user2"."id" =
"User__fromRelationships"."user2id"
WHERE "user"."id" = $1) "distinctAlias"
ORDER BY "user_id" ASC
LIMIT 1 -- PARAMETERS: ["5ffede46-b0f4-4a26-ba8e-dff34bb1bc2f"]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment