SELECT
    resMember.strnama_dealer,
    resMember.strkode_dealer,
    resMember.strnama_upline,
    a.intid_dealer,
    resCabang.strnama_cabang,
    resUnit.strnama_unit,
    a.intid_unit,
    a.intid_jpenjualan,
    a.inttotal_omset,
    a.intid_week,
    a.datetgl
FROM
nota a
LEFT JOIN (
    SELECT
        strnama_dealer,
        strkode_dealer,
        strnama_upline,
        intid_dealer
    FROM
        member
) resMember ON resMember.intid_dealer = a.intid_dealer
LEFT JOIN (
    SELECT
        intid_unit,
        strnama_unit
    FROM
        unit
) resUnit ON resUnit.intid_unit = a.intid_unit
LEFT JOIN (
    SELECT
        intid_cabang,
        strnama_cabang
    FROM
        cabang
) resCabang ON resCabang.intid_cabang = a.intid_cabang
WHERE
     a.is_dp = 0
GROUP BY
    resMember.strnama_dealer,
    resMember.strkode_dealer,
    resMember.strnama_upline,
    resMember.intid_dealer
ORDER BY
    resCabang.strnama_cabang ASC