Query : EXPLAIN EXTENDED SELECT 1 AS `rank`, a.`reference`, fc_remove_sign (a.`reference`) code_ref, COUNT(a.`lead_id`) AS `leads`, COUNT( IF( a.`type` = 'OPPORTUNITY', a.`lead_id`, NULL ) ) AS `opps`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 0, a.`lead_id`, NULL ) ) AS `x`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 1, a.`lead_id`, NULL ) ) AS `x1`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 2, a.`lead_id`, NULL ) ) AS `x2`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 3, a.`lead_id`, NULL ) ) AS `x3`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 4, a.`lead_id`, NULL ) ) AS `x4` FROM (SELECT `fc_get_reference_name` ( IFNULL( fl.`source_type`, vs.`source_type` ), vs.`source_reference` ) AS `reference`, vs.`lead_id`, l.`type`, c.`ID` AS `contract_id`, IF( c.`ID` IS NOT NULL, `fc_get_total_months` (l.`created`, c.`date_created`), NULL ) AS `total_months` FROM `v_trial_service_sources` vs LEFT JOIN `v_field_log_sources` fl ON vs.`lead_id` = fl.`lead_id` INNER JOIN `crm_leads` l ON l.`ID` = vs.`lead_id` LEFT JOIN `crm_contracts` c ON l.`ID` = c.`potential_id` AND c.`total_price_internal` > 0 AND c.`website` = vs.`website` WHERE vs.`lead_id` IS NOT NULL AND ( fl.`source_type` = 2 OR ( fl.`source_type` IS NULL AND vs.`source_type` = 2 ) ) AND l.`service_id` = IF( NAME_CONST('p_service_id', NULL) IS NULL OR NAME_CONST('p_service_id', NULL) = - 1, l.`service_id`, NAME_CONST('p_service_id', NULL) ) AND l.`created` BETWEEN NAME_CONST( '_date_created_from', _latin1 '2016-11-01' COLLATE 'latin1_swedish_ci' ) AND NAME_CONST( '_date_created_to', _latin1 '2016-11-30' COLLATE 'latin1_swedish_ci' ) AND vs.`created` BETWEEN NAME_CONST( '_date_created_from', _latin1 '2016-11-01' COLLATE 'latin1_swedish_ci' ) AND NAME_CONST( '_date_created_to', _latin1 '2016-11-30' COLLATE 'latin1_swedish_ci' )) a GROUP BY a.`reference` HAVING a.`reference` = IFNULL( NAME_CONST('p_source_ref', NULL), a.`reference` ) UNION SELECT 1 AS `rank`, a.`reference`, fc_remove_sign (a.`reference`) code_ref, COUNT(a.`lead_id`) AS `leads`, COUNT( IF( a.`type` = 'OPPORTUNITY', a.`lead_id`, NULL ) ) AS `opps`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 0, a.`lead_id`, NULL ) ) AS `x`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 1, a.`lead_id`, NULL ) ) AS `x1`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 2, a.`lead_id`, NULL ) ) AS `x2`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 3, a.`lead_id`, NULL ) ) AS `x3`, COUNT( IF( a.`contract_id` IS NOT NULL AND a.`total_months` = 4, a.`lead_id`, NULL ) ) AS `x4` FROM (SELECT `fc_get_reference_name` (l.`source_type`, NULL) AS `reference`, l.`ID` AS `lead_id`, l.`type`, c.`ID` AS `contract_id`, IF( c.`ID` IS NOT NULL, `fc_get_total_months` (l.`created`, c.`date_created`), NULL ) AS `total_months` FROM `crm_leads` l LEFT JOIN `crm_contracts` c ON l.`ID` = c.`potential_id` AND c.`total_price_internal` > 0 WHERE l.`source_type` != 2 AND l.`service_id` = IF( NAME_CONST('p_service_id', NULL) IS NULL OR NAME_CONST('p_service_id', NULL) = - 1, l.`service_id`, NAME_CONST('p_service_id', NULL) ) AND l.`created` BETWEEN NAME_CONST( '_date_created_from', _latin1 '2016-11-01' COLLATE 'latin1_swedish_ci' ) AND NAME_CONST( '_date_created_to', _latin1 '2016-11-30' COLLATE 'latin1_swedish_ci' )) a GROUP BY a.`reference` HAVING a.`reference` LIKE IFNULL( NAME_CONST('p_source_ref', NULL), a.`reference` )

EXPLAIN EXTENDED Result

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	ts	ALL	PRIMARY,lead_id	(NULL)	(NULL)	(NULL)	191993	50.00	Using where; Using temporary; Using filesort
1	PRIMARY	l	eq_ref	PRIMARY	PRIMARY	4	dms.ts.lead_id	1	100.00	Using where
1	PRIMARY	c	ref	potential_id	potential_id	9	dms.ts.lead_id	1	100.00	Using where
1	PRIMARY	tsm1	ref	trial_service_id,meta_key,meta_value	trial_service_id	4	dms.ts.id	3	100.00	Using where
1	PRIMARY	tsm2	ref	trial_service_id,meta_key	trial_service_id	4	dms.ts.id	3	100.00	Using where
1	PRIMARY	<derived6>	ref	key0	key0	5	dms.ts.lead_id	10	100.00	Using where
6	DERIVED	fl	index	TableColumnRow	Idx_row_id	5	(NULL)	27841	100.00	Using where
3	UNION	l	ALL	(NULL)	(NULL)	(NULL)	(NULL)	1031135	100.00	Using where; Using temporary; Using filesort
3	UNION	c	ref	potential_id	potential_id	9	dms.l.id	1	100.00	Using where
(NULL)	UNION RESULT	<union1,3>	ALL	(NULL)	(NULL)	(NULL)	(NULL)	(NULL)	(NULL)