Skip to content

Instantly share code, notes, and snippets.

@mickhansen

mickhansen/gist:8187382

Created December 30, 2013 20:08
Show Gist options
  • Save mickhansen/8187382 to your computer and use it in GitHub Desktop.
Save mickhansen/8187382 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT "As".*, "B"."id" AS "B.id", "B"."createdAt" AS "B.createdAt", "B"."updatedAt" AS "B.updatedAt", "B"."CId" AS "B.CId", "B.C"."id" AS "B.C.id", "B.C"."createdAt" AS "B.C.createdAt", "B.C"."updatedAt" AS "B.C.updatedAt", "B.C"."DId" AS "B.C.DId", "B.C.D"."id" AS "B.C.D.id", "B.C.D"."createdAt" AS "B.C.D.createdAt", "B.C.D"."updatedAt" AS "B.C.D.updatedAt", "B.C.D"."EId" AS "B.C.D.EId", "B.C.D.E"."id" AS "B.C.D.E.id", "B.C.D.E"."createdAt" AS "B.C.D.E.createdAt", "B.C.D.E"."updatedAt" AS "B.C.D.E.updatedAt", "B.C.D.E"."FId" AS "B.C.D.E.FId", "B.C.D.E.F"."id" AS "B.C.D.E.F.id", "B.C.D.E.F"."createdAt" AS "B.C.D.E.F.createdAt", "B.C.D.E.F"."updatedAt" AS "B.C.D.E.F.updatedAt", "B.C.D.E.F"."GId" AS "B.C.D.E.F.GId", "B.C.D.E.F.G"."id" AS "B.C.D.E.F.G.id", "B.C.D.E.F.G"."createdAt" AS "B.C.D.E.F.G.createdAt", "B.C.D.E.F.G"."updatedAt" AS "B.C.D.E.F.G.updatedAt", "B.C.D.E.F.G"."HId" AS "B.C.D.E.F.G.HId", "B.C.D.E.F.G.H"."id" AS "B.C.D.E.F.G.H.id", "B.C.D.E.F.G.H"."createdAt" AS "B.C.D.E.F.G.H.createdAt", "B.C.D.E.F.G.H"."updatedAt" AS "B.C.D.E.F.G.H.updatedAt" FROM "As" LEFT OUTER JOIN "Bs" AS "B" ON "B"."id" = "As"."BId" LEFT OUTER JOIN "Cs" AS "B.C" ON "B.C"."id" = "B"."CId" LEFT OUTER JOIN "Ds" AS "B.C.D" ON "B.C.D"."id" = "B.C"."DId" LEFT OUTER JOIN "Es" AS "B.C.D.E" ON "B.C.D.E"."id" = "B.C.D"."EId" LEFT OUTER JOIN "Fs" AS "B.C.D.E.F" ON "B.C.D.E.F"."id" = "B.C.D.E"."FId" LEFT OUTER JOIN "Gs" AS "B.C.D.E.F.G" ON "B.C.D.E.F.G"."id" = "B.C.D.E.F"."GId" LEFT OUTER JOIN "Hs" AS "B.C.D.E.F.G.H" ON "B.C.D.E.F.G.H"."id" = "B.C.D.E.F.G"."HId";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment