select "$Outer"."name2" as "name",
    "$Outer"."name3" as "public.orgunits.name",
    "$Inner"."year" as "public.stream_enrolments.public.proMfva20mxuLC1A2TbWILU27REbak=",
    "$Outer"."stype" as "public.stream_enrolments.public.proVDtXT3Q6kdsDzjJo9SxMXuhYlFg=",
    "$Outer"."unswid2" as "public.stream_enrolments.public.proJN0eIvhZuqXhbPgiCJ41deO99CQ="
from
(
    select "$Outer"."id2" as "id2",
        "$Outer"."name2" as "name2",
        "$Outer"."stype2" as "stype2",
        "$Outer"."name3" as "name3",
        "$Outer"."semester" as "semester",
        "$Outer"."stype" as "stype",
        "$Inner"."unswid" as "unswid2"
    from
    (
        select "_"."id2" as "id2",
            "_"."name2" as "name2",
            "_"."stype2" as "stype2",
            "_"."name" as "name3",
            "_"."semester" as "semester",
            "_"."id" as "id3",
            "_"."stype" as "stype"
        from
        (
            select "_"."id2",
                "_"."name2",
                "_"."stype2",
                "_"."name",
                "_"."semester",
                "_"."id",
                "_"."stype"
            from
            (
                select "$Outer"."id2",
                    "$Outer"."name2",
                    "$Outer"."stype2",
                    "$Outer"."name",
                    "$Outer"."semester",
                    "$Inner"."id",
                    "$Inner"."stype"
                from
                (
                    select "$Outer"."id2" as "id2",
                        "$Outer"."name2" as "name2",
                        "$Outer"."stype" as "stype2",
                        "$Outer"."name" as "name",
                        "$Inner"."student" as "student",
                        "$Inner"."semester" as "semester"
                    from
                    (
                        select "$Outer"."id2",
                            "$Outer"."name2",
                            "$Outer"."offeredby",
                            "$Outer"."stype",
                            "$Outer"."firstoffer",
                            "$Outer"."lastoffer",
                            "$Outer"."name",
                            "$Inner"."partof"
                        from
                        (
                            select "$Outer"."id2",
                                "$Outer"."name2",
                                "$Outer"."offeredby",
                                "$Outer"."stype",
                                "$Outer"."firstoffer",
                                "$Outer"."lastoffer",
                                "$Inner"."name"
                            from
                            (
                                select "id" as "id2",
                                    "name" as "name2",
                                    "offeredby" as "offeredby",
                                    "stype" as "stype",
                                    "firstoffer" as "firstoffer",
                                    "lastoffer" as "lastoffer"
                                from "public"."streams" "$Table"
                            ) "$Outer"
                            left outer join "public"."orgunits" "$Inner" on ("$Outer"."offeredby" = "$Inner"."id")
                        ) "$Outer"
                        left outer join "public"."stream_enrolments" "$Inner" on ("$Outer"."id2" = "$Inner"."stream")
                    ) "$Outer"
                    left outer join "public"."program_enrolments" "$Inner" on ("$Outer"."partof" = "$Inner"."id")
                ) "$Outer"
                left outer join "public"."students" "$Inner" on ("$Outer"."student" = "$Inner"."id")
            ) "_"
            where "_"."stype" = 'local' and "_"."stype" is not null
        ) "_"
        where ("_"."name" <> 'Accounting' or "_"."name" is null) and ("_"."name" <> 'Economics' or "_"."name" is null)
    ) "$Outer"
    left outer join "public"."people" "$Inner" on ("$Outer"."id3" = "$Inner"."id")
) "$Outer"
left outer join "public"."semesters" "$Inner" on ("$Outer"."semester" = "$Inner"."id")