ORIGINAL QUERY:
SELECT 
  (SUM(CASE WHEN service_state.is_acknowledged = 'y' THEN 1 ELSE 0 END)) AS services_acknowledged, 
  (SUM(CASE WHEN service.active_checks_enabled = 'y' THEN 1 ELSE 0 END)) AS services_active_checks_enabled, 
  (SUM(CASE WHEN service.passive_checks_enabled = 'y' THEN 1 ELSE 0 END)) AS services_passive_checks_enabled, 
  (SUM(CASE WHEN service_state.soft_state = 2 AND service_state.is_handled = 'y' THEN 1 ELSE 0 END)) AS services_critical_handled, 
  (SUM(CASE WHEN service_state.soft_state = 2 AND service_state.is_handled = 'n' THEN 1 ELSE 0 END)) AS services_critical_unhandled, 
  (SUM(CASE WHEN service.event_handler_enabled = 'y' THEN 1 ELSE 0 END)) AS services_event_handler_enabled, 
  (SUM(CASE WHEN service.flapping_enabled = 'y' THEN 1 ELSE 0 END)) AS services_flapping_enabled, 
  (SUM(CASE WHEN service.notifications_enabled = 'y' THEN 1 ELSE 0 END)) AS services_notifications_enabled, 
  (SUM(CASE WHEN service_state.soft_state = 0 THEN 1 ELSE 0 END)) AS services_ok, 
  (SUM(CASE WHEN service_state.soft_state = 99 THEN 1 ELSE 0 END)) AS services_pending, 
  (SUM(CASE WHEN service_state.is_problem = 'y' AND service_state.is_acknowledged = 'n' THEN 1 ELSE 0 END)) AS services_problems_unacknowledged, 
  (SUM(CASE WHEN service.id IS NOT NULL THEN 1 ELSE 0 END)) AS services_total, 
  (SUM(CASE WHEN service_state.soft_state = 3 AND service_state.is_handled = 'y' THEN 1 ELSE 0 END)) AS services_unknown_handled, 
  (SUM(CASE WHEN service_state.soft_state = 3 AND service_state.is_handled = 'n' THEN 1 ELSE 0 END)) AS services_unknown_unhandled, 
  (SUM(CASE WHEN service_state.soft_state = 1 AND service_state.is_handled = 'y' THEN 1 ELSE 0 END)) AS services_warning_handled, 
  (SUM(CASE WHEN service_state.soft_state = 1 AND service_state.is_handled = 'n' THEN 1 ELSE 0 END)) AS services_warning_unhandled 
FROM service LEFT JOIN service_state ON service_state.service_id = service.id 
WHERE EXISTS (
  SELECT (1)  
  FROM customvar_flat sub_customvar_flat 
  INNER JOIN host_customvar sub_customvar_flat_host_customvar ON sub_customvar_flat_host_customvar.customvar_id = sub_customvar_flat.customvar_id 
  INNER JOIN host sub_customvar_flat_host ON sub_customvar_flat_host.id = sub_customvar_flat_host_customvar.host_id 
  LEFT JOIN service sub_customvar_flat_host_service ON sub_customvar_flat_host_service.host_id = sub_customvar_flat_host.id 
  WHERE (sub_customvar_flat_host_service.id = service.id) 
    AND ((sub_customvar_flat.flatname = 'customer') AND (sub_customvar_flat.flatvalue = 'ANSELL'))
)
      
      
      
ADAPTED QUERY:
SELECT 
  (SUM(CASE WHEN service_state.is_acknowledged = 'y' THEN 1 ELSE 0 END)) AS services_acknowledged, 
  (SUM(CASE WHEN service.active_checks_enabled = 'y' THEN 1 ELSE 0 END)) AS services_active_checks_enabled, 
  (SUM(CASE WHEN service.passive_checks_enabled = 'y' THEN 1 ELSE 0 END)) AS services_passive_checks_enabled, 
  (SUM(CASE WHEN service_state.soft_state = 2 AND service_state.is_handled = 'y' THEN 1 ELSE 0 END)) AS services_critical_handled, 
  (SUM(CASE WHEN service_state.soft_state = 2 AND service_state.is_handled = 'n' THEN 1 ELSE 0 END)) AS services_critical_unhandled, 
  (SUM(CASE WHEN service.event_handler_enabled = 'y' THEN 1 ELSE 0 END)) AS services_event_handler_enabled, 
  (SUM(CASE WHEN service.flapping_enabled = 'y' THEN 1 ELSE 0 END)) AS services_flapping_enabled, 
  (SUM(CASE WHEN service.notifications_enabled = 'y' THEN 1 ELSE 0 END)) AS services_notifications_enabled, 
  (SUM(CASE WHEN service_state.soft_state = 0 THEN 1 ELSE 0 END)) AS services_ok, 
  (SUM(CASE WHEN service_state.soft_state = 99 THEN 1 ELSE 0 END)) AS services_pending, 
  (SUM(CASE WHEN service_state.is_problem = 'y' AND service_state.is_acknowledged = 'n' THEN 1 ELSE 0 END)) AS services_problems_unacknowledged, 
  (SUM(CASE WHEN service.id IS NOT NULL THEN 1 ELSE 0 END)) AS services_total, 
  (SUM(CASE WHEN service_state.soft_state = 3 AND service_state.is_handled = 'y' THEN 1 ELSE 0 END)) AS services_unknown_handled, 
  (SUM(CASE WHEN service_state.soft_state = 3 AND service_state.is_handled = 'n' THEN 1 ELSE 0 END)) AS services_unknown_unhandled, 
  (SUM(CASE WHEN service_state.soft_state = 1 AND service_state.is_handled = 'y' THEN 1 ELSE 0 END)) AS services_warning_handled, 
  (SUM(CASE WHEN service_state.soft_state = 1 AND service_state.is_handled = 'n' THEN 1 ELSE 0 END)) AS services_warning_unhandled 
FROM service LEFT JOIN service_state ON service_state.service_id = service.id 
WHERE service.id in (
  SELECT (sub_customvar_flat_host_service.id) 
  FROM customvar_flat sub_customvar_flat 
    INNER JOIN host_customvar sub_customvar_flat_host_customvar ON sub_customvar_flat_host_customvar.customvar_id = sub_customvar_flat.customvar_id 
    INNER JOIN host sub_customvar_flat_host ON sub_customvar_flat_host.id = sub_customvar_flat_host_customvar.host_id 
    LEFT JOIN service sub_customvar_flat_host_service ON sub_customvar_flat_host_service.host_id = sub_customvar_flat_host.id 
  WHERE ((sub_customvar_flat.flatname = 'customer') AND (sub_customvar_flat.flatvalue = 'ANSELL'))
)