Skip to content

Instantly share code, notes, and snippets.

@joaobibiano
Created July 6, 2020 21:49
Show Gist options
  • Save joaobibiano/100bf332fff0f6c24faa1b0501fc4cf3 to your computer and use it in GitHub Desktop.
Save joaobibiano/100bf332fff0f6c24faa1b0501fc4cf3 to your computer and use it in GitHub Desktop.
SELECT
"class"."id" AS "class_id",
"class"."createdAt" AS "class_createdAt",
"class"."updatedAt" AS "class_updatedAt",
"class"."title" AS "class_title"
FROM
"class" "class"
INNER JOIN
"time_availability" "timeAvailability"
ON "timeAvailability"."classId" = "class"."id"
INNER JOIN
"class_picture" "pictures"
ON "pictures"."classId" = "class"."id"
INNER JOIN
"file" "file"
ON "pictures"."fileId" = "pictures"."fileId"
INNER JOIN
"class_extra_detail" "classExtraDetails"
ON "classExtraDetails"."classId" = "class"."id"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment