SELECT "spaceName", "spaceIsCovered", "spaceSurfaceType", "spacePrice", "spaceComplexID", "complexName", "complexLocation", "complexEmail", "complexPhone", "complexOpeningHour",
"complexClosingHour"

FROM "Space"
JOIN "SportsComplex" ON "spaceComplexID" = "complexID"
LEFT JOIN "SpaceSports" ON "spaceID" = "spaceSportsSpaceID"
LEFT JOIN "Sport" ON "sportID" = "spaceSportsSportID"

WHERE
"spaceID" = 51;