Object : Dashboard
Function : SQL 2
Date : 28/09/2025 00:53:25
select program_name, periode, criteria1, criteria2, criteria3,       ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1,       ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2,       ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 429 and idprog = 14

Object : Dashboard
Function : SQL 2
Date : 28/09/2025 00:53:25
select program_name, periode, criteria1, criteria2, criteria3,       ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1,       ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2,       ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 429 and idprog = 14

Object : Dashboard
Function : SQL 2
Date : 28/09/2025 19:18:30
select program_name, periode, criteria1, criteria2, criteria3,       ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1,       ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2,       ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 403 and idprog = 14

Object : Dashboard
Function : SQL 2
Date : 28/09/2025 19:18:30
select program_name, periode, criteria1, criteria2, criteria3,       ifnull(qty1,0) as qty1, ifnull(target_qty1,0) as target_qty1, ifnull(subtotal1,0) as subtotal1, ifnull(result_persen1,0) as result_persen1, ifnull(bonus1,0) as bonus1, ifnull(nilai_bonus1,0) as nilai_bonus1, ifnull(cashback1,0) as cashback1, ifnull(nilai_cashback1,0) as nilai_cashback1,       ifnull(qty2,0) as qty2, ifnull(target_qty2,0) as target_qty2, ifnull(subtotal2,0) as subtotal2, ifnull(result_persen2,0) as result_persen2, ifnull(bonus2,0) as bonus2, ifnull(nilai_bonus2,0) as nilai_bonus2, ifnull(cashback2,0) as cashback2, ifnull(nilai_cashback2,0) as nilai_cashback2,       ifnull(qty3,0) as qty3, ifnull(target_qty3,0) as target_qty3, ifnull(subtotal3,0) as subtotal3, ifnull(result_persen3,0) as result_persen3, ifnull(bonus3,0) as bonus3, ifnull(nilai_bonus3,0) as nilai_bonus3, ifnull(cashback3,0) as cashback3, ifnull(nilai_cashback3,0) as nilai_cashback3 from ep0670 where userid = 403 and idprog = 14