query.sql

SELECT
  "repo_namespace"."id",
  "repo_namespace"."name",
  "repo_repouser"."namespace_ptr_id",
  "repo_repouser"."password",
  "repo_repouser"."last_login",
  "repo_repouser"."is_superuser",
  "repo_repouser"."email",
  "repo_repouser"."is_staff",
  "repo_repouser"."is_active",
  "repo_repouser"."date_joined",
  "repo_organization"."namespace_ptr_id"
FROM "repo_namespace"
  LEFT OUTER JOIN "repo_repouser"
    ON ("repo_namespace"."id" =
        "repo_repouser"."namespace_ptr_id")
  LEFT OUTER JOIN "repo_organization"
    ON ("repo_namespace"."id" =
        "repo_organization"."namespace_ptr_id")
  LEFT OUTER JOIN "repo_organizationteam"
    ON ("repo_organization"."namespace_ptr_id" =
        "repo_organizationteam"."organization_id")
  LEFT OUTER JOIN "repo_organizationteam_users"
    ON ("repo_organizationteam"."id" =
        "repo_organizationteam_users"."organizationteam_id")
  LEFT OUTER JOIN "repo_organizationteam_permissions"
    ON ("repo_organizationteam"."id" =
        "repo_organizationteam_permissions"."organizationteam_id")
  LEFT OUTER JOIN "repo_permission"
    ON ("repo_organizationteam_permissions"."permission_id" =
        "repo_permission"."id")
WHERE ("repo_repouser"."namespace_ptr_id" = 1
       OR ("repo_organizationteam_users"."repouser_id" = 1
           AND ("repo_organizationteam"."is_owner_team" = TRUE
                OR "repo_permission"."slug" = project.create)))