SELECT member.strnama_dealer, member.strkode_dealer, member.strnama_upline, member.intid_dealer,
unit.strnama_unit, unit.intid_unit, cabang.strnama_cabang,
(
    SELECT sum(a.inttotal_omset) total_omset
    FROM nota a
    WHERE
    a.intid_week in (
        SELECT intid_week FROM week
        WHERE
        intbulan='03'
        AND inttahun='2014'
    )
    AND YEAR(a.datetgl)='2014'
    AND a.intid_unit = unit.intid_unit
    AND a.intid_jpenjualan != 8
    AND a.intid_jpenjualan != 10
    AND a.intid_jpenjualan != 11
    AND a.intid_jpenjualan != 12
    AND a.is_dp = 0
) omset_unit,
(
    SELECT sum(a.inttotal_omset) total_omset
    FROM nota a
    WHERE
    a.intid_week in (
        SELECT intid_week FROM week
        WHERE
        intbulan='03'
        AND inttahun='2014'
    )
    AND YEAR(a.datetgl)='2014'
    AND a.intid_unit = unit.intid_unit
    AND a.intid_jpenjualan = 1
    AND a.is_dp = 0
) omset_unit_asli
FROM nota, member, unit, cabang
WHERE
nota.intid_dealer = member.intid_dealer
AND member.intid_unit = unit.intid_unit
AND member.intid_cabang = cabang.intid_cabang
AND member.intlevel_dealer = 1
AND nota.intid_week in (
    SELECT intid_week FROM week
    WHERE intbulan='03' AND inttahun='2014'
)
AND YEAR(nota.datetgl)='2014'
AND nota.is_dp = 0
GROUP BY member.strnama_dealer, member.strkode_dealer, member.strnama_upline, member.intid_dealer
ORDER BY cabang.strnama_cabang asc