SELECT month_target AS bulan,SUM(b.`target_sales`) AS target_month,SUM(c.`sales_2012`) AS last_month,
			COALESCE(total_sales,
0)AS actual, COALESCE(total_point,
0)AS regular, COALESCE(bonus_point,
0)AS bonus,
			COALESCE((total_point+COALESCE(bonus_point,
0)),
0)AS total,COALESCE(g.rebate,
0)AS rebate,COALESCE(g.rebate_pf,
0)AS rebate_pf

			FROM mstr_outlet a
			LEFT JOIN mstr_sales_target b ON a.`outlet_id` = b.`outlet_id`
			LEFT JOIN mstr_sales_2012 c ON c.`outlet_id` = a.`outlet_id` AND b.`month_target` = c.`month_2012`
			LEFT JOIN (SELECT e.pulau_id_alias,e.nama_pulau_alias,MONTHNAME(tgl_transaksi)AS bulan, SUM(sales)AS total_sales,
			 SUM(point_satuan)AS total_point
			FROM trx_transaksi a
			INNER JOIN mstr_outlet b ON a.no_id = b.outlet_id
			INNER JOIN ms_city_alias c ON b.city_id_alias = c.city_id_alias
			INNER JOIN mstr_distributor d ON b.distributor_id = d.distributor_id
			INNER JOIN ms_pulau_alias e ON e.pulau_id_alias = b.region_id
			INNER JOIN trx_transaksi_barang g ON g.kd_transaksi = a.kd_transaksi WHERE a.status='A'AND d.distributor_id  = '200053'
			GROUP BY bulan )d ON d.bulan = b.month_target
			LEFT JOIN (SELECT b.outlet_id,MONTHNAME(tgl_transaksi)AS bulan,SUM(point_satuan)AS bonus_point
			FROM trx_transaksi a
			INNER JOIN trx_transaksi_barang i ON a.kd_transaksi = i.kd_transaksi
			LEFT JOIN mstr_outlet b ON b.outlet_id = a.no_id
			LEFT JOIN ms_city_alias c ON b.city_id_alias = c.city_id_alias
			LEFT JOIN mstr_distributor d ON b.distributor_id = d.distributor_id
			LEFT JOIN ms_pulau_alias e ON e.pulau_id_alias = b.region_id WHERE STATUS='B' AND d.distributor_id  = '200053'
			GROUP BY bulan)e ON e.bulan = b.month_target
			LEFT JOIN ( SELECT MONTHNAME(tgl_transaksi)AS bulan, e.pulau_id_alias FROM trx_transaksi a
			INNER JOIN mstr_outlet b ON a.no_id = b.outlet_id
			INNER JOIN ms_city_alias c ON b.city_id_alias = c.city_id_alias
			INNER JOIN mstr_distributor d ON b.distributor_id = d.distributor_id
			INNER JOIN ms_pulau_alias e ON e.pulau_id_alias = b.region_id
			INNER JOIN trx_transaksi_barang f ON f.kd_transaksi = a.kd_transaksi
			INNER JOIN mstr_item g ON g.item_code = f.kd_produk
			INNER JOIN mstr_signature h ON h.kode_signature = g.kode_signature
			INNER JOIN mstr_category i ON i.kode_category = h.kode_category WHERE d.distributor_id = '200053' GROUP BY bulan )f ON
			f.bulan = b.month_target
			LEFT JOIN (
			SELECT bulan,rebate,rebate_pf FROM `trx_rebate_list_bulan1` a
			INNER JOIN mstr_outlet b ON a.outlet_id = b.outlet_id
			WHERE  a.distributor_id = '200053'
			UNION
			SELECT bulan,rebate,rebate_pf FROM `trx_rebate_list_bulan2` a
			INNER JOIN mstr_outlet b ON a.outlet_id = b.outlet_id
			WHERE  a.distributor_id = '200053'
			UNION
			SELECT bulan,rebate,rebate_pf FROM `trx_rebate_list_bulan3` a
			INNER JOIN mstr_outlet b ON a.outlet_id = b.outlet_id
			WHERE  a.distributor_id = '200053'
			UNION
			SELECT bulan,rebate,rebate_pf FROM `trx_rebate_list_bulan4` a
			INNER JOIN mstr_outlet b ON a.outlet_id = b.outlet_id
			WHERE  a.distributor_id = '200053')g ON g.bulan = b.month_target

			WHERE b.distributor_id ='200053' GROUP BY b.month_target ORDER BY b.month_target DESC