SELECT (SELECT COUNT(*) 
				FROM `hr__leave_application` `a` 
				LEFT JOIN `user__employment_detail` `b` ON `b`.`user_id` = `a`.`user_id` 
				LEFT JOIN `company__position` `c` ON `c`.`id` = `b`.`position_id` 
				WHERE `a`.`is_delete` = 0
				AND `c`.`parent_id` <  3 AND year(date_from) = 2019) as leaveTotal, (SELECT COUNT(*) 
				FROM `hr__leave_application` `a` 
				LEFT JOIN `user__employment_detail` `b` ON `b`.`user_id` = `a`.`user_id` 
				LEFT JOIN `company__position` `c` ON `c`.`id` = `b`.`position_id` 
				WHERE `a`.`is_delete` = 0
				AND `c`.`parent_id` <  3 AND year(date_from) = 2019 AND `a`.`status` = 1) as leavePending, (SELECT COUNT(*) 
				FROM `hr__leave_application` `a` 
				LEFT JOIN `user__employment_detail` `b` ON `b`.`user_id` = `a`.`user_id` 
				LEFT JOIN `company__position` `c` ON `c`.`id` = `b`.`position_id` 
				WHERE `a`.`is_delete` = 0
				AND `c`.`parent_id` <  3 AND year(date_from) = 2019 AND `a`.`status` = 2) as leaveApproved, (SELECT COUNT(*) 
				FROM `hr__leave_application` `a` 
				LEFT JOIN `user__employment_detail` `b` ON `b`.`user_id` = `a`.`user_id` 
				LEFT JOIN `company__position` `c` ON `c`.`id` = `b`.`position_id` 
				WHERE `a`.`is_delete` = 0
				AND `c`.`parent_id` <  3 AND year(date_from) = 2019 AND `a`.`status` = 3) as leaveRejected, (SELECT COUNT(*) 
				FROM `hr__leave_application` `a` 
				LEFT JOIN `user__employment_detail` `b` ON `b`.`user_id` = `a`.`user_id` 
				LEFT JOIN `company__position` `c` ON `c`.`id` = `b`.`position_id` 
				WHERE `a`.`is_delete` = 0
				AND `c`.`parent_id` <  3 AND year(date_from) = 2019 AND `a`.`status` = 4) as leaveCancelled