B7EZ707x

1CREATE TEMPORARY TABLE IF NOT EXISTS temp_estadisticas AS ( SELECT IF ( receptions.id IS NOT NULL AND (receptions.analyzable = 0 OR receptions.analyzable_biopsy = 0 OR receptions.analyzable_plasma = 0), 'No analizable', IF ( reference_centres.id IS NOT NULL AND reference_centres.sample_result_id = 2, 'No evaluable', IF ( reference_centres.id IS NOT NULL AND reference_centres.sample_result_id = 1 AND reference_centres.braf_mutation = 0, 'Wild Type', IF ( reference_centres.id IS NOT NULL AND reference_centres.sample_result_id = 1 AND reference_centres.braf_mutation = 1, 'Mutado', 'Inválido' )))) AS result, zonas.id AS zona_id, zonas.name AS zona_name, IF ( receptions.id IS NOT NULL AND ( receptions.analyzable = 0 OR receptions.analyzable_biopsy = 0 OR receptions.analyzable_plasma = 0 ), receptions.updated_at, samples.report_date ) AS finished_date FROM samples, solicitudes, solicitude_determinations, medical_service_pathology_determinations, hospitals, provinces, zonas, receptions, reference_centres WHERE samples.id IS NOT NULL AND samples.state = 9 AND solicitudes.sample_id = samples.id AND solicitude_determinations.solicitude_id = solicitudes.id AND medical_service_pathology_determinations.id = solicitude_determinations.medical_service_pathology_determinations_id AND medical_service_pathology_determinations.determination_id = 1 AND hospitals.id = samples.hospital_id AND provinces.id = hospitals.province_id AND zonas.id = provinces.zona_id AND zonas.id IN (1, 2, 3, 4, 5) AND receptions.sample_id = samples.id AND reference_centres.sample_id = samples.id ); SELECT SUM(IF (zona_id = 1, 1, null)) AS '1 Total', SUM(IF (result = 'No analizable' AND zona_id = 1, 1, null)) AS '1 No analizable', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'No evaluable' AND zona_id = 1, 1, null)) AS '1 No evaluable', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Wild Type' AND zona_id = 1, 1, null)) AS '1 Wild Type', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Mutado' AND zona_id = 1, 1, null)) AS '1 Mutado', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Inválido' AND zona_id = 1, 1, null)) AS '1 Inválido', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 1 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '1 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (zona_id = 2, 1, null)) AS '2 Total', SUM(IF (result = 'No analizable' AND zona_id = 2, 1, null)) AS '2 No analizable', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'No evaluable' AND zona_id = 2, 1, null)) AS '2 No evaluable', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Wild Type' AND zona_id = 2, 1, null)) AS '2 Wild Type', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Mutado' AND zona_id = 2, 1, null)) AS '2 Mutado', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Inválido' AND zona_id = 2, 1, null)) AS '2 Inválido', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 2 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '2 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (zona_id = 3, 1, null)) AS '3 Total', SUM(IF (result = 'No analizable' AND zona_id = 3, 1, null)) AS '3 No analizable', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'No evaluable' AND zona_id = 3, 1, null)) AS '3 No evaluable', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Wild Type' AND zona_id = 3, 1, null)) AS '3 Wild Type', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Mutado' AND zona_id = 3, 1, null)) AS '3 Mutado', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Inválido' AND zona_id = 3, 1, null)) AS '3 Inválido', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 3 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '3 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (zona_id = 4, 1, null)) AS '4 Total', SUM(IF (result = 'No analizable' AND zona_id = 4, 1, null)) AS '4 No analizable', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'No evaluable' AND zona_id = 4, 1, null)) AS '4 No evaluable', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Wild Type' AND zona_id = 4, 1, null)) AS '4 Wild Type', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Mutado' AND zona_id = 4, 1, null)) AS '4 Mutado', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Inválido' AND zona_id = 4, 1, null)) AS '4 Inválido', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 4 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '4 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (zona_id = 5, 1, null)) AS '5 Total', SUM(IF (result = 'No analizable' AND zona_id = 5, 1, null)) AS '5 No analizable', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No analizable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No analizable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'No evaluable' AND zona_id = 5, 1, null)) AS '5 No evaluable', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'No evaluable' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 No evaluable 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Wild Type' AND zona_id = 5, 1, null)) AS '5 Wild Type', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Wild Type' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Wild Type 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Mutado' AND zona_id = 5, 1, null)) AS '5 Mutado', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Mutado' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Mutado 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF (result = 'Inválido' AND zona_id = 5, 1, null)) AS '5 Inválido', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', SUM(IF ( result = 'Inválido' AND zona_id = 5 AND finished_date >= '1971-01-01 01:00:00' AND finished_date <= '1971-01-01 01:00:00', 1, null) ) AS '5 Inválido 1971-01-01 01:00:00 - 1971-01-01 01:00:00', COUNT(*) AS total FROM temp_estadisticas;