INSERT INTO frm_fmmnx (Formulario,Nombre,Apellido,NroDocumento,Edad,EstadoCivil,NivelEducativo,Departamento_desc,Distrito_desc,Barrio_manual,FechaDefuncion,LugarDefuncion,Etnia,Codreg,Subcreg,Coddist,Establecimiento,Embarazada,Embarazada6sem,Embarazada12mes,CausaA,CausaA_CIE10,CausaB,CausaB_CIE10,CausaC,CausaC_CIE10,CausaD,CausaD_CIE10,OtrasCausas,CausaBasica_CIE10,Departamento,Distrito,CausaBasica_CIE10sub,NroOrden,CausaA_sub,CausaB_sub,CausaC_sub,CausaD_sub,Codigo,Region_desc,Distrito_es_desc,Establecimiento_desc,Año,Formulario1,Formulario2,Formulario3,Formulario4,FichaNotificacion,CertificadoDefuncion,HistoriaClinica,AutopsiaVerbal,Necropsia,Otros,ControlPrenatal,ConfirmadaMM,Barrio_desc,Barrio) SELECT fmmnx_matriz.nformu,fmmnx_matriz.nombre,fmmnx_matriz.apellido,fmmnx_matriz.nrodoc,fmmnx_matriz.valedad,fmmnx_estado_civil.Descripcion,fmmnx_nivel_educativo.Descripcion,departamentos.nomdpto,distritos.nomdist,fmmnx_matriz.barrior, str_to_date(fmmnx_matriz.fechadef,'%d/%m/%Y)'),fmmnx_matriz.lugmue,fmmnx_etnias.Descripcion,fmmnx_matriz.codrsan1,fmmnx_matriz.subcreg,fmmnx_matriz.coddist,fmmnx_matriz.codest,fmmnx_matriz.embaraz,fmmnx_matriz.emb6sem,fmmnx_matriz.emb12m,fmmnx_matriz.causaa,fmmnx_matriz.codcie10a,fmmnx_matriz.causab,fmmnx_matriz.codcie10b,fmmnx_matriz.causac,fmmnx_matriz.codcie10c,fmmnx_matriz.causad,fmmnx_matriz.codcie10d,fmmnx_matriz.otrestp,fmmnx_matriz.codcie10cb,fmmnx_matriz.coddptor,fmmnx_matriz.coddistr,fmmnx_matriz.codcie6,fmmnx_matriz.norden,fmmnx_matriz.codcie1,fmmnx_matriz.codcie2,fmmnx_matriz.codcie3,fmmnx_matriz.codcie4,IF((embaraz = 'SI' OR emb6sem = 'SI' OR emb12m = 'SI') OR (codcie10cb BETWEEN 'O00' AND 'O99') OR codcie10cb = 'A34' OR codcie10cb = 'C58' OR (codcie10cb = 'D39' AND codcie6 = '2') OR (codcie10cb = 'E23' AND codcie6 = '0') OR (codcie10cb = 'F53' AND codcie6 = '0') OR (codcie10cb = 'F53' AND codcie6 = '1') OR (codcie10cb = 'F53' AND codcie6 = '2') OR (codcie10cb = 'F53' AND codcie6 = '3') OR (codcie10cb = 'F53' AND codcie6 = '4') OR (codcie10cb = 'F53' AND codcie6 = '5') OR (codcie10cb = 'F53' AND codcie6 = '6') OR (codcie10cb = 'F53' AND codcie6 = '7') OR (codcie10cb = 'F53' AND codcie6 = '8') OR (codcie10cb = 'F53' AND codcie6 = '9') OR (codcie10cb = 'M83' AND codcie6 = '0') OR ((codcie10cb BETWEEN 'B20' AND 'B24') AND (embaraz = 'SI' OR emb6sem = 'SI' OR emb12m = 'SI')),'MM', IF((embaraz = 'SI' OR emb6sem = 'SI' OR emb12m = 'SI') AND (codcie10cb = 'A40' OR codcie10cb = 'A41' OR (codcie10cb = 'A54' AND codcie6 = '2') OR codcie10cb = 'A90' OR codcie10cb = 'A91' OR codcie10cb = 'D50' OR codcie10cb = 'D62' OR ((codcie10cb = 'D64' AND codcie6 = '9') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'D65' OR (codcie10cb = 'D69' AND codcie6 = '3') OR (codcie10cb = 'D69' AND codcie6 = '4') OR (codcie10cb = 'D69' AND codcie6 = '5') OR (codcie10cb = 'D69' AND codcie6 = '6') OR (codcie10cb = 'D69' AND codcie6 = '8') OR (codcie10cb = 'D69' AND codcie6 = '9') OR codcie10cb = 'E86' OR codcie10cb = 'E87' OR (codcie10cb = 'E88' AND codcie6 = '9') OR (codcie10cb = 'E89' AND codcie6 = '6') OR (codcie10cb = 'E89' AND codcie6 = '9') OR ((codcie10cb = 'G40') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'G93' AND codcie6 = '1') OR (codcie10cb = 'G93' AND codcie6 = '2') OR (codcie10cb = 'G93' AND codcie6 = '5') OR (codcie10cb = 'G93' AND codcie6 = '6') OR (codcie10cb = 'G93' AND codcie6 = '9') OR ((codcie10cb = 'I10') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I12') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I13') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I14') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I15') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I21') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I26') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I42') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'I46' AND codcie6 = '9') OR codcie10cb = 'I47' OR codcie10cb = 'I48' OR codcie10cb = 'I49' OR ((codcie10cb = 'I50') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'I60' AND 'I69') AND ((codcie10cb <> 'I67' AND codcie6 <> '1') AND (codcie10cb <> 'I67' AND codcie6 <> '3') AND (codcie10cb <> 'I67' AND codcie6 <> '5') AND (codcie10cb <> 'I68' AND codcie6 <> '0') AND (codcie10cb <> 'I68' AND codcie6 <> '1') AND (codcie10cb <> 'I68' AND codcie6 <> '2')) AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'I74' OR ((codcie10cb BETWEEN 'J10' AND 'J11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'J12' AND 'J18') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J81') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J96') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'J98' AND codcie6 = '9') OR codcie10cb = 'K65' OR ((codcie10cb = 'K72') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'M32' OR ((codcie10cb BETWEEN 'N17' AND 'N19') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'N18' OR (codcie10cb BETWEEN 'N70' AND 'N73') OR (codcie10cb = 'N74' AND codcie6 = '8') OR codcie10cb = 'N92' OR (codcie10cb = 'N93' AND codcie6 = '8') OR (codcie10cb = 'N93' AND codcie6 = '9') OR (codcie10cb = 'R10' AND codcie6 = '0') OR (codcie10cb = 'R40' AND codcie6 = '2') OR codcie10cb = 'R50' OR codcie10cb = 'R56' OR (codcie10cb = 'R57' AND codcie6 = '1') OR (codcie10cb = 'R57' AND codcie6 = '2') OR (codcie10cb = 'R57' AND codcie6 = '8') OR codcie10cb = 'R58' OR (codcie10cb = 'R68' AND codcie6 = '8') OR codcie10cb = 'R98' OR codcie10cb = 'R99' OR codcie10cb = 'Y48' OR (codcie10cb = 'Y57' AND codcie6 = '9')),'AP', IF((embaraz = 'SD' OR emb6sem = 'SD' OR emb12m = 'SD' OR embaraz = 'NO SABE' OR emb6sem = 'NO SABE' OR emb12m = 'NO SABE') AND (codcie10cb = 'A40' OR codcie10cb = 'A41' OR (codcie10cb = 'A54' AND codcie6 = '2') OR codcie10cb = 'A90' OR codcie10cb = 'A91' OR codcie10cb = 'D50' OR codcie10cb = 'D62' OR ((codcie10cb = 'D64' AND codcie6 = '9') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'D65' OR (codcie10cb = 'D69' AND codcie6 = '3') OR (codcie10cb = 'D69' AND codcie6 = '4') OR (codcie10cb = 'D69' AND codcie6 = '5') OR (codcie10cb = 'D69' AND codcie6 = '6') OR (codcie10cb = 'D69' AND codcie6 = '8') OR (codcie10cb = 'D69' AND codcie6 = '9') OR codcie10cb = 'E86' OR codcie10cb = 'E87' OR (codcie10cb = 'E88' AND codcie6 = '9') OR (codcie10cb = 'E89' AND codcie6 = '6') OR (codcie10cb = 'E89' AND codcie6 = '9') OR ((codcie10cb = 'G40') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'G93' AND codcie6 = '1') OR (codcie10cb = 'G93' AND codcie6 = '2') OR (codcie10cb = 'G93' AND codcie6 = '5') OR (codcie10cb = 'G93' AND codcie6 = '6') OR (codcie10cb = 'G93' AND codcie6 = '9') OR ((codcie10cb = 'I10') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I12') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I13') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I14') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I15') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I21') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I26') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I42') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'I46' AND codcie6 = '9') OR codcie10cb = 'I47' OR codcie10cb = 'I48' OR codcie10cb = 'I49' OR ((codcie10cb = 'I50') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'I60' AND 'I69') AND ((codcie10cb <> 'I67' AND codcie6 <> '1') AND (codcie10cb <> 'I67' AND codcie6 <> '3') AND (codcie10cb <> 'I67' AND codcie6 <> '5') AND (codcie10cb <> 'I68' AND codcie6 <> '0') AND (codcie10cb <> 'I68' AND codcie6 <> '1') AND (codcie10cb <> 'I68' AND codcie6 <> '2')) AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'I74' OR ((codcie10cb BETWEEN 'J10' AND 'J11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'J12' AND 'J18') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J81') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J96') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'J98' AND codcie6 = '9') OR codcie10cb = 'K65' OR ((codcie10cb = 'K72') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'M32' OR ((codcie10cb BETWEEN 'N17' AND 'N19') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'N18' OR (codcie10cb BETWEEN 'N70' AND 'N73') OR (codcie10cb = 'N74' AND codcie6 = '8') OR codcie10cb = 'N92' OR (codcie10cb = 'N93' AND codcie6 = '8') OR (codcie10cb = 'N93' AND codcie6 = '9') OR (codcie10cb = 'R10' AND codcie6 = '0') OR (codcie10cb = 'R40' AND codcie6 = '2') OR codcie10cb = 'R50' OR codcie10cb = 'R56' OR (codcie10cb = 'R57' AND codcie6 = '1') OR (codcie10cb = 'R57' AND codcie6 = '2') OR (codcie10cb = 'R57' AND codcie6 = '8') OR codcie10cb = 'R58' OR (codcie10cb = 'R68' AND codcie6 = '8') OR codcie10cb = 'R98' OR codcie10cb = 'R99' OR codcie10cb = 'Y48' OR (codcie10cb = 'Y57' AND codcie6 = '9')),'PR', IF((embaraz = 'NO' OR emb6sem = 'NO' OR emb12m = 'NO') AND (codcie10cb = 'A40' OR codcie10cb = 'A41' OR (codcie10cb = 'A54' AND codcie6 = '2') OR codcie10cb = 'A90' OR codcie10cb = 'A91' OR codcie10cb = 'D50' OR codcie10cb = 'D62' OR ((codcie10cb = 'D64' AND codcie6 = '9') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'D65' OR (codcie10cb = 'D69' AND codcie6 = '3') OR (codcie10cb = 'D69' AND codcie6 = '4') OR (codcie10cb = 'D69' AND codcie6 = '5') OR (codcie10cb = 'D69' AND codcie6 = '6') OR (codcie10cb = 'D69' AND codcie6 = '8') OR (codcie10cb = 'D69' AND codcie6 = '9') OR codcie10cb = 'E86' OR codcie10cb = 'E87' OR (codcie10cb = 'E88' AND codcie6 = '9') OR (codcie10cb = 'E89' AND codcie6 = '6') OR (codcie10cb = 'E89' AND codcie6 = '9') OR ((codcie10cb = 'G40') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'G93' AND codcie6 = '1') OR (codcie10cb = 'G93' AND codcie6 = '2') OR (codcie10cb = 'G93' AND codcie6 = '5') OR (codcie10cb = 'G93' AND codcie6 = '6') OR (codcie10cb = 'G93' AND codcie6 = '9') OR ((codcie10cb = 'I10') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I12') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I13') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I14') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I15') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I21') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I26') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I42') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'I46' AND codcie6 = '9') OR codcie10cb = 'I47' OR codcie10cb = 'I48' OR codcie10cb = 'I49' OR ((codcie10cb = 'I50') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'I60' AND 'I69') AND ((codcie10cb <> 'I67' AND codcie6 <> '1') AND (codcie10cb <> 'I67' AND codcie6 <> '3') AND (codcie10cb <> 'I67' AND codcie6 <> '5') AND (codcie10cb <> 'I68' AND codcie6 <> '0') AND (codcie10cb <> 'I68' AND codcie6 <> '1') AND (codcie10cb <> 'I68' AND codcie6 <> '2')) AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'I74' OR ((codcie10cb BETWEEN 'J10' AND 'J11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'J12' AND 'J18') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J81') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J96') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'J98' AND codcie6 = '9') OR codcie10cb = 'K65' OR ((codcie10cb = 'K72') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'M32' OR ((codcie10cb BETWEEN 'N17' AND 'N19') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'N18' OR (codcie10cb BETWEEN 'N70' AND 'N73') OR (codcie10cb = 'N74' AND codcie6 = '8') OR codcie10cb = 'N92' OR (codcie10cb = 'N93' AND codcie6 = '8') OR (codcie10cb = 'N93' AND codcie6 = '9') OR (codcie10cb = 'R10' AND codcie6 = '0') OR (codcie10cb = 'R40' AND codcie6 = '2') OR codcie10cb = 'R50' OR codcie10cb = 'R56' OR (codcie10cb = 'R57' AND codcie6 = '1') OR (codcie10cb = 'R57' AND codcie6 = '2') OR (codcie10cb = 'R57' AND codcie6 = '8') OR codcie10cb = 'R58' OR (codcie10cb = 'R68' AND codcie6 = '8') OR codcie10cb = 'R98' OR codcie10cb = 'R99' OR codcie10cb = 'Y48' OR (codcie10cb = 'Y57' AND codcie6 = '9')),'PP','')))),(SELECT nomreg FROM regiones WHERE codreg = fmmnx_matriz.codrsan1 AND subcreg = fmmnx_matriz.subcreg),(SELECT nomdist FROM distritos WHERE coddpto = fmmnx_matriz.codrsan1 AND coddist = fmmnx_matriz.coddist),(SELECT CONCAT(tiposerv,' - ',nomserv) FROM establecimientos WHERE codigoesta = codest),YEAR(str_to_date(fechadef,'%d/%m/%Y')),'SD','SD','SD','SD','SD','SD','SD','SD','SD','SD','SD','SD',IF((SELECT nombarrio FROM barrios WHERE coddpto = fmmnx_matriz.coddptor AND coddist = fmmnx_matriz.coddistr AND codbarrio = fmmnx_matriz.codbarrior) <> '',(SELECT nombarrio FROM barrios WHERE coddpto = fmmnx_matriz.coddptor AND coddist = fmmnx_matriz.coddistr AND codbarrio = fmmnx_matriz.codbarrior),'-- Cargar Manual --'),IF((SELECT nombarrio FROM barrios WHERE coddpto = fmmnx_matriz.coddptor AND coddist = fmmnx_matriz.coddistr AND codbarrio = fmmnx_matriz.codbarrior) <> '',codbarrior,'-2') FROM fmmnx_matriz INNER JOIN `dataserver`.`fmmnx_nivel_educativo` ON (`fmmnx_matriz`.`nivedu` = `fmmnx_nivel_educativo`.`IdNivelEducativo`) LEFT JOIN `dataserver`.`regiones` ON (`fmmnx_matriz`.`codrsan1` = `regiones`.`codreg`) AND (`fmmnx_matriz`.`subcreg` = `regiones`.`subcreg`) LEFT JOIN `dataserver`.`distritos` ON (`fmmnx_matriz`.`coddist` = `distritos`.`coddist`) AND (`fmmnx_matriz`.`codrsan1` = `distritos`.`coddpto`) LEFT JOIN `dataserver`.`establecimientos` ON (`fmmnx_matriz`.`codest` = `establecimientos`.`codigoesta`) INNER JOIN `dataserver`.`fmmnx_estado_civil` ON (`fmmnx_matriz`.`estciv` = `fmmnx_estado_civil`.`IdEstadoCivil`) LEFT JOIN `dataserver`.`fmmnx_etnias` ON (`fmmnx_matriz`.`codetnia` = `fmmnx_etnias`.`IdEtnias`) INNER JOIN `dataserver`.`departamentos` ON (`fmmnx_matriz`.`coddptor` = `departamentos`.`coddpto`) LEFT JOIN `dataserver`.`barrios` ON (`fmmnx_matriz`.`codbarrior` = `barrios`.`codbarrio`) AND (`fmmnx_matriz`.`coddptor` = `barrios`.`coddpto`) AND (`fmmnx_matriz`.`coddistr` = `barrios`.`coddist`) WHERE fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 54) ON DUPLICATE KEY UPDATE CausaA = fmmnx_matriz.causaa,CausaA_CIE10 = fmmnx_matriz.codcie10a,CausaB = fmmnx_matriz.causab,CausaB_CIE10 = fmmnx_matriz.codcie10b,CausaC = fmmnx_matriz.causac,CausaC_CIE10 = fmmnx_matriz.codcie10c,CausaD = fmmnx_matriz.causad,CausaD_CIE10 = fmmnx_matriz.codcie10d,OtrasCausas = fmmnx_matriz.otrestp,CausaBasica_CIE10 = fmmnx_matriz.codcie10cb,Codigo = IF((embaraz = 'SI' OR emb6sem = 'SI' OR emb12m = 'SI') OR (codcie10cb BETWEEN 'O00' AND 'O99') OR codcie10cb = 'A34' OR codcie10cb = 'C58' OR (codcie10cb = 'D39' AND codcie6 = '2') OR (codcie10cb = 'E23' AND codcie6 = '0') OR (codcie10cb = 'F53' AND codcie6 = '0') OR (codcie10cb = 'F53' AND codcie6 = '1') OR (codcie10cb = 'F53' AND codcie6 = '2') OR (codcie10cb = 'F53' AND codcie6 = '3') OR (codcie10cb = 'F53' AND codcie6 = '4') OR (codcie10cb = 'F53' AND codcie6 = '5') OR (codcie10cb = 'F53' AND codcie6 = '6') OR (codcie10cb = 'F53' AND codcie6 = '7') OR (codcie10cb = 'F53' AND codcie6 = '8') OR (codcie10cb = 'F53' AND codcie6 = '9') OR (codcie10cb = 'M83' AND codcie6 = '0') OR ((codcie10cb BETWEEN 'B20' AND 'B24') AND (embaraz = 'SI' OR emb6sem = 'SI' OR emb12m = 'SI')),'MM', IF((embaraz = 'SI' OR emb6sem = 'SI' OR emb12m = 'SI') AND (codcie10cb = 'A40' OR codcie10cb = 'A41' OR (codcie10cb = 'A54' AND codcie6 = '2') OR codcie10cb = 'A90' OR codcie10cb = 'A91' OR codcie10cb = 'D50' OR codcie10cb = 'D62' OR ((codcie10cb = 'D64' AND codcie6 = '9') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'D65' OR (codcie10cb = 'D69' AND codcie6 = '3') OR (codcie10cb = 'D69' AND codcie6 = '4') OR (codcie10cb = 'D69' AND codcie6 = '5') OR (codcie10cb = 'D69' AND codcie6 = '6') OR (codcie10cb = 'D69' AND codcie6 = '8') OR (codcie10cb = 'D69' AND codcie6 = '9') OR codcie10cb = 'E86' OR codcie10cb = 'E87' OR (codcie10cb = 'E88' AND codcie6 = '9') OR (codcie10cb = 'E89' AND codcie6 = '6') OR (codcie10cb = 'E89' AND codcie6 = '9') OR ((codcie10cb = 'G40') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'G93' AND codcie6 = '1') OR (codcie10cb = 'G93' AND codcie6 = '2') OR (codcie10cb = 'G93' AND codcie6 = '5') OR (codcie10cb = 'G93' AND codcie6 = '6') OR (codcie10cb = 'G93' AND codcie6 = '9') OR ((codcie10cb = 'I10') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I12') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I13') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I14') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I15') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I21') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I26') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I42') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'I46' AND codcie6 = '9') OR codcie10cb = 'I47' OR codcie10cb = 'I48' OR codcie10cb = 'I49' OR ((codcie10cb = 'I50') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'I60' AND 'I69') AND ((codcie10cb <> 'I67' AND codcie6 <> '1') AND (codcie10cb <> 'I67' AND codcie6 <> '3') AND (codcie10cb <> 'I67' AND codcie6 <> '5') AND (codcie10cb <> 'I68' AND codcie6 <> '0') AND (codcie10cb <> 'I68' AND codcie6 <> '1') AND (codcie10cb <> 'I68' AND codcie6 <> '2')) AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'I74' OR ((codcie10cb BETWEEN 'J10' AND 'J11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'J12' AND 'J18') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J81') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J96') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'J98' AND codcie6 = '9') OR codcie10cb = 'K65' OR ((codcie10cb = 'K72') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'M32' OR ((codcie10cb BETWEEN 'N17' AND 'N19') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'N18' OR (codcie10cb BETWEEN 'N70' AND 'N73') OR (codcie10cb = 'N74' AND codcie6 = '8') OR codcie10cb = 'N92' OR (codcie10cb = 'N93' AND codcie6 = '8') OR (codcie10cb = 'N93' AND codcie6 = '9') OR (codcie10cb = 'R10' AND codcie6 = '0') OR (codcie10cb = 'R40' AND codcie6 = '2') OR codcie10cb = 'R50' OR codcie10cb = 'R56' OR (codcie10cb = 'R57' AND codcie6 = '1') OR (codcie10cb = 'R57' AND codcie6 = '2') OR (codcie10cb = 'R57' AND codcie6 = '8') OR codcie10cb = 'R58' OR (codcie10cb = 'R68' AND codcie6 = '8') OR codcie10cb = 'R98' OR codcie10cb = 'R99' OR codcie10cb = 'Y48' OR (codcie10cb = 'Y57' AND codcie6 = '9')),'AP', IF((embaraz = 'SD' OR emb6sem = 'SD' OR emb12m = 'SD' OR embaraz = 'NO SABE' OR emb6sem = 'NO SABE' OR emb12m = 'NO SABE') AND (codcie10cb = 'A40' OR codcie10cb = 'A41' OR (codcie10cb = 'A54' AND codcie6 = '2') OR codcie10cb = 'A90' OR codcie10cb = 'A91' OR codcie10cb = 'D50' OR codcie10cb = 'D62' OR ((codcie10cb = 'D64' AND codcie6 = '9') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'D65' OR (codcie10cb = 'D69' AND codcie6 = '3') OR (codcie10cb = 'D69' AND codcie6 = '4') OR (codcie10cb = 'D69' AND codcie6 = '5') OR (codcie10cb = 'D69' AND codcie6 = '6') OR (codcie10cb = 'D69' AND codcie6 = '8') OR (codcie10cb = 'D69' AND codcie6 = '9') OR codcie10cb = 'E86' OR codcie10cb = 'E87' OR (codcie10cb = 'E88' AND codcie6 = '9') OR (codcie10cb = 'E89' AND codcie6 = '6') OR (codcie10cb = 'E89' AND codcie6 = '9') OR ((codcie10cb = 'G40') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'G93' AND codcie6 = '1') OR (codcie10cb = 'G93' AND codcie6 = '2') OR (codcie10cb = 'G93' AND codcie6 = '5') OR (codcie10cb = 'G93' AND codcie6 = '6') OR (codcie10cb = 'G93' AND codcie6 = '9') OR ((codcie10cb = 'I10') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I12') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I13') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I14') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I15') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I21') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I26') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I42') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'I46' AND codcie6 = '9') OR codcie10cb = 'I47' OR codcie10cb = 'I48' OR codcie10cb = 'I49' OR ((codcie10cb = 'I50') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'I60' AND 'I69') AND ((codcie10cb <> 'I67' AND codcie6 <> '1') AND (codcie10cb <> 'I67' AND codcie6 <> '3') AND (codcie10cb <> 'I67' AND codcie6 <> '5') AND (codcie10cb <> 'I68' AND codcie6 <> '0') AND (codcie10cb <> 'I68' AND codcie6 <> '1') AND (codcie10cb <> 'I68' AND codcie6 <> '2')) AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'I74' OR ((codcie10cb BETWEEN 'J10' AND 'J11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'J12' AND 'J18') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J81') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J96') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'J98' AND codcie6 = '9') OR codcie10cb = 'K65' OR ((codcie10cb = 'K72') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'M32' OR ((codcie10cb BETWEEN 'N17' AND 'N19') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'N18' OR (codcie10cb BETWEEN 'N70' AND 'N73') OR (codcie10cb = 'N74' AND codcie6 = '8') OR codcie10cb = 'N92' OR (codcie10cb = 'N93' AND codcie6 = '8') OR (codcie10cb = 'N93' AND codcie6 = '9') OR (codcie10cb = 'R10' AND codcie6 = '0') OR (codcie10cb = 'R40' AND codcie6 = '2') OR codcie10cb = 'R50' OR codcie10cb = 'R56' OR (codcie10cb = 'R57' AND codcie6 = '1') OR (codcie10cb = 'R57' AND codcie6 = '2') OR (codcie10cb = 'R57' AND codcie6 = '8') OR codcie10cb = 'R58' OR (codcie10cb = 'R68' AND codcie6 = '8') OR codcie10cb = 'R98' OR codcie10cb = 'R99' OR codcie10cb = 'Y48' OR (codcie10cb = 'Y57' AND codcie6 = '9')),'PR', IF((embaraz = 'NO' OR emb6sem = 'NO' OR emb12m = 'NO') AND (codcie10cb = 'A40' OR codcie10cb = 'A41' OR (codcie10cb = 'A54' AND codcie6 = '2') OR codcie10cb = 'A90' OR codcie10cb = 'A91' OR codcie10cb = 'D50' OR codcie10cb = 'D62' OR ((codcie10cb = 'D64' AND codcie6 = '9') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'D65' OR (codcie10cb = 'D69' AND codcie6 = '3') OR (codcie10cb = 'D69' AND codcie6 = '4') OR (codcie10cb = 'D69' AND codcie6 = '5') OR (codcie10cb = 'D69' AND codcie6 = '6') OR (codcie10cb = 'D69' AND codcie6 = '8') OR (codcie10cb = 'D69' AND codcie6 = '9') OR codcie10cb = 'E86' OR codcie10cb = 'E87' OR (codcie10cb = 'E88' AND codcie6 = '9') OR (codcie10cb = 'E89' AND codcie6 = '6') OR (codcie10cb = 'E89' AND codcie6 = '9') OR ((codcie10cb = 'G40') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'G93' AND codcie6 = '1') OR (codcie10cb = 'G93' AND codcie6 = '2') OR (codcie10cb = 'G93' AND codcie6 = '5') OR (codcie10cb = 'G93' AND codcie6 = '6') OR (codcie10cb = 'G93' AND codcie6 = '9') OR ((codcie10cb = 'I10') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I12') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I13') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I14') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I15') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I21') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I26') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'I42') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'I46' AND codcie6 = '9') OR codcie10cb = 'I47' OR codcie10cb = 'I48' OR codcie10cb = 'I49' OR ((codcie10cb = 'I50') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'I60' AND 'I69') AND ((codcie10cb <> 'I67' AND codcie6 <> '1') AND (codcie10cb <> 'I67' AND codcie6 <> '3') AND (codcie10cb <> 'I67' AND codcie6 <> '5') AND (codcie10cb <> 'I68' AND codcie6 <> '0') AND (codcie10cb <> 'I68' AND codcie6 <> '1') AND (codcie10cb <> 'I68' AND codcie6 <> '2')) AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'I74' OR ((codcie10cb BETWEEN 'J10' AND 'J11') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb BETWEEN 'J12' AND 'J18') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J81') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR ((codcie10cb = 'J96') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR (codcie10cb = 'J98' AND codcie6 = '9') OR codcie10cb = 'K65' OR ((codcie10cb = 'K72') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'M32' OR ((codcie10cb BETWEEN 'N17' AND 'N19') AND (fetal = "f" AND sexo = 2 AND grupoed = 4 AND (valedad >= 10 AND valedad <= 49))) OR codcie10cb = 'N18' OR (codcie10cb BETWEEN 'N70' AND 'N73') OR (codcie10cb = 'N74' AND codcie6 = '8') OR codcie10cb = 'N92' OR (codcie10cb = 'N93' AND codcie6 = '8') OR (codcie10cb = 'N93' AND codcie6 = '9') OR (codcie10cb = 'R10' AND codcie6 = '0') OR (codcie10cb = 'R40' AND codcie6 = '2') OR codcie10cb = 'R50' OR codcie10cb = 'R56' OR (codcie10cb = 'R57' AND codcie6 = '1') OR (codcie10cb = 'R57' AND codcie6 = '2') OR (codcie10cb = 'R57' AND codcie6 = '8') OR codcie10cb = 'R58' OR (codcie10cb = 'R68' AND codcie6 = '8') OR codcie10cb = 'R98' OR codcie10cb = 'R99' OR codcie10cb = 'Y48' OR (codcie10cb = 'Y57' AND codcie6 = '9')),'PP',''))))[]