Revisi Query Revenue

select periode, (flash_corp + mitra_pro + jarvis + kofera + regular) as revenue
from(
SELECT
    periode,
    sum( flash_corp ) AS flash_corp,
    sum( mitra_pro ) AS mitra_pro,
    sum( jarvis ) AS jarvis,
    sum( kofera ) AS kofera,
    sum( regular ) AS regular
FROM
    (
SELECT
    DATE_FORMAT( o_tgl_aktif, '%Y-%m' ) AS periode,
    IF(sum( o_flash_corp ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_flash_corp, '|', 1 ) )) AS flash_corp,
    IF(sum( o_mitrapro ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_mitrapro, '|', 1 ) )) AS mitra_pro,
    IF(sum( o_jarvis ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_jarvis, '|', 1 ) )) AS jarvis,
    IF(sum( o_kofera ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_kofera, '|', 1 ) )) AS kofera,
    IF(sum( o_paket_post_regular ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_paket_post_regular, '|', 1 ) )) AS regular
FROM
    trans_teleammiscl AS trans_teleam
WHERE
    ( o_flash_corp REGEXP '^[0-9]' OR o_mitrapro REGEXP '^[0-9]' OR o_jarvis REGEXP '^[0-9]' OR o_kofera REGEXP '^[0-9]' OR o_paket_post_regular REGEXP '^[0-9]' )
    AND reason_call = 'AGREE'
    AND status_call = 'CONTACTED'
    AND sub_reason_call = 'Aktif Paket MyBusiness'
    AND o_tgl_aktif IS NOT NULL
    AND DATE_FORMAT( o_tgl_aktif, '%Y-%m' ) != '0000-00'
    GROUP BY DATE_FORMAT(o_tgl_aktif,'%Y-%m')
    UNION ALL
SELECT
    DATE_FORMAT( o_tgl_aktif, '%Y-%m' ) AS periode,
    IF(sum( o_flash_corp ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_flash_corp, '|', 1 ) )) AS flash_corp,
    IF(sum( o_mitrapro ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_mitrapro, '|', 1 ) )) AS mitra_pro,
    IF(sum( o_jarvis ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_jarvis, '|', 1 ) )) AS jarvis,
    IF(sum( o_kofera ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_kofera, '|', 1 ) )) AS kofera,
    IF(sum( o_paket_post_regular ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_paket_post_regular, '|', 1 ) )) AS regular
FROM
    trans_teleampp AS trans_teleam
WHERE
    ( o_flash_corp REGEXP '^[0-9]' OR o_mitrapro REGEXP '^[0-9]' OR o_jarvis REGEXP '^[0-9]' OR o_kofera REGEXP '^[0-9]' OR o_paket_post_regular REGEXP '^[0-9]' )
    AND reason_call = 'AGREE'
    AND status_call = 'CONTACTED'
    AND sub_reason_call = 'Aktif Paket MyBusiness'
    AND o_tgl_aktif IS NOT NULL
    AND DATE_FORMAT( o_tgl_aktif, '%Y-%m' ) != '0000-00'
    GROUP BY DATE_FORMAT(o_tgl_aktif,'%Y-%m')
    UNION ALL
SELECT
    DATE_FORMAT( o_tgl_aktif, '%Y-%m' ) AS periode,
    IF(sum( o_flash_corp ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_flash_corp, '|', 1 ) )) AS flash_corp,
    IF(sum( o_mitrapro ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_mitrapro, '|', 1 ) )) AS mitra_pro,
    IF(sum( o_jarvis ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_jarvis, '|', 1 ) )) AS jarvis,
    IF(sum( o_kofera ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_kofera, '|', 1 ) )) AS kofera,
    IF(sum( o_paket_post_regular ) IS NULL , 0 ,sum( SUBSTRING_INDEX( o_paket_post_regular, '|', 1 ) )) AS regular
FROM
    trans_teleamnonpp AS trans_teleam
WHERE
    ( o_flash_corp REGEXP '^[0-9]' OR o_mitrapro REGEXP '^[0-9]' OR o_jarvis REGEXP '^[0-9]' OR o_kofera REGEXP '^[0-9]' OR o_paket_post_regular REGEXP '^[0-9]' )
    AND reason_call = 'AGREE'
    AND status_call = 'CONTACTED'
    AND sub_reason_call = 'Aktif Paket MyBusiness'
    AND o_tgl_aktif IS NOT NULL
    AND DATE_FORMAT( o_tgl_aktif, '%Y-%m' ) != '0000-00'
    GROUP BY DATE_FORMAT(o_tgl_aktif,'%Y-%m')
    ) AS source
WHERE
    periode IS NOT NULL
GROUP BY
    periode
    ) as t