SELECT
        member.strnama_dealer,
        member.strkode_dealer,
        member.strnama_upline,
        cabang.strnama_cabang,
        unit.strnama_unit,
        resOmsetUnit.intid_dealer,
        resOmsetUnit.intid_unit,
        resOmsetUnit.intid_jpenjualan,
        resOmsetUnit.inttotal_omset,
        resOmsetUnit.intid_week,
        resOmsetUnit.datetgl
    FROM
        member,unit,cabang,
        (
            SELECT
                a.intid_cabang,
                a.intid_dealer,
                a.intid_unit,
                a.intid_jpenjualan,
                a.inttotal_omset,
                a.intid_week,
                a.datetgl
            FROM
                nota a,
                unit b
            WHERE
                a.intid_unit = b.intid_unit
            AND a.is_dp = 0
            GROUP BY
                a.intid_unit,
                b.intid_unit,
                a.intid_week
        ) resOmsetUnit
    where
    member.intid_dealer = resOmsetUnit.intid_dealer
    AND unit.intid_unit = resOmsetUnit.intid_unit
    AND cabang.intid_cabang = resOmsetUnit.intid_cabang
    GROUP BY
        member.strnama_dealer,
        member.strkode_dealer,
        member.strnama_upline,
        member.intid_dealer
    ORDER BY
        cabang.strnama_cabang ASC