SELECT l.id_leads,l.id_sales,s.nama_sales,b.bulan,DATE_FORMAT(l.tanggal, '%Y') tahun
					,CONCAT(
					IF((SELECT COUNT(id_leads) FROM leads lsub WHERE lsub.id_sales=l.id_sales) IS NULL, 0, (SELECT COUNT(id_leads) FROM leads lsub WHERE lsub.id_sales=l.id_sales)),'/',
					(SELECT target_leads FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)pencapaian_leads
					,CONCAT(
					IF((SELECT COUNT(id_prospek) FROM prospek psub JOIN assessment asub USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_sales=l.id_sales) IS NULL, 0, (SELECT COUNT(id_prospek) FROM prospek psub JOIN assessment asub USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_sales=l.id_sales)),'/',
					(SELECT target_prospek FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)pencapaian_prospek
					,
					CONCAT(
					IF((SELECT (SELECT COUNT(id_fu_prospek) FROM fu_prospek JOIN prospek.status USING (id_status) JOIN prospek USING (id_prospek)JOIN assessment USING (id_assessment)JOIN leads USING (id_leads)WHERE prospek.status.id_status='8' AND leads.`id_sales`=l.`id_sales`)
					FROM prospek p JOIN assessment a USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_leads=l.id_leads) IS NULL, 0, (SELECT (SELECT COUNT(id_fu_prospek) FROM fu_prospek JOIN prospek.status USING (id_status) JOIN prospek USING (id_prospek)JOIN assessment USING (id_assessment)JOIN leads USING (id_leads)WHERE prospek.status.id_status='8' AND leads.`id_sales`=l.`id_sales`)
					FROM prospek p JOIN assessment a USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_leads=l.id_leads)),'/',
					(SELECT target_deal FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)pencapaian_deal
					,
					(IF((SELECT COUNT(id_leads) FROM leads lsub WHERE lsub.id_sales=l.id_sales) IS NULL, 0, (SELECT COUNT(id_leads) FROM leads lsub WHERE lsub.id_sales=l.id_sales))/
					(SELECT target_leads FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))*
					(SELECT bobot_leads FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)persentase_leads
					,
					(IF((SELECT COUNT(id_prospek) FROM prospek psub JOIN assessment asub USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_sales=l.id_sales) IS NULL, 0, (SELECT COUNT(id_prospek) FROM prospek psub JOIN assessment asub USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_sales=l.id_sales))/
					(SELECT target_prospek FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))*
					(SELECT bobot_prospek FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)persentase_prospek
					,
					(IF((SELECT (SELECT COUNT(id_fu_prospek) FROM fu_prospek JOIN prospek.status USING (id_status) JOIN prospek USING (id_prospek)JOIN assessment USING (id_assessment) JOIN leads USING (id_leads) WHERE prospek.status.id_status='8' AND leads.`id_sales`=l.`id_sales`)
					FROM prospek p JOIN assessment a USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_leads=l.id_leads) IS NULL, 0, (SELECT (SELECT COUNT(id_fu_prospek) FROM fu_prospek JOIN prospek.status USING (id_status) JOIN prospek USING (id_prospek)JOIN assessment USING (id_assessment) JOIN leads USING (id_leads) WHERE prospek.status.id_status='8' AND leads.`id_sales`=l.`id_sales`)
					FROM prospek p JOIN assessment a USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_leads=l.id_leads))/
					(SELECT target_deal FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))*
					(SELECT bobot_deal FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)persentase_deal
					,
					(
					(IF((SELECT COUNT(id_leads) FROM leads lsub WHERE lsub.id_sales=l.id_sales) IS NULL, 0, (SELECT COUNT(id_leads) FROM leads lsub WHERE lsub.id_sales=l.id_sales))/
					(SELECT target_leads FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))*
					(SELECT bobot_leads FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)
					+
					(IF((SELECT COUNT(id_prospek) FROM prospek psub JOIN assessment asub USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_sales=l.id_sales) IS NULL, 0, (SELECT COUNT(id_prospek) FROM prospek psub JOIN assessment asub USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_sales=l.id_sales))/
					(SELECT target_prospek FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))*
					(SELECT bobot_prospek FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)
					+
					(IF((SELECT (SELECT COUNT(id_fu_prospek) FROM fu_prospek JOIN prospek.status USING (id_status) WHERE prospek.status.id_status='8')
					FROM prospek p JOIN assessment a USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_leads=l.id_leads) IS NULL, 0, (SELECT (SELECT COUNT(id_fu_prospek) FROM fu_prospek JOIN prospek.status USING (id_status) WHERE prospek.status.id_status='8')
					FROM prospek p JOIN assessment a USING (id_assessment) JOIN leads lsub USING (id_leads) WHERE lsub.id_leads=l.id_leads))/
					(SELECT target_deal FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))*
					(SELECT bobot_deal FROM bobot bsub WHERE CONCAT(id_bulan,'-',tahun)=DATE_FORMAT(l.tanggal, '%m-%Y'))
					)
					)hasil
				FROM leads l
				JOIN sales s USING (id_sales)
				JOIN bulan b ON DATE_FORMAT(l.tanggal, '%m')=b.id_bulan
				WHERE DATE_FORMAT(l.tanggal, '%Y-%m')='$tahun_bulan'
				AND l.id_sales='$sales_id'
				GROUP BY l.`id_sales`, DATE_FORMAT(l.tanggal, '%Y%m')