SELECT 

"ARENA2_ACCIDENTES"."LID_ACCIDENTE" as "LID_ACCIDENTE",
"ARENA2_VEHICULOS"."LID_VEHICULO" as "LID_VEHICULO",
"ARENA2_CONDUCTORES"."LID_CONDUCTOR" as "LID_CONDUCTOR",
"ARENA2_PASAJEROS"."LID_PASAJERO" as "LID_PASAJERO",

"ARENA2_ACCIDENTES"."COD_INFORME" as "AC_COD_INFORME",
"ARENA2_ACCIDENTES"."ID_ACCIDENTE" as "AC_ID_ACCIDENTE",


"ARENA2_ACCIDENTES"."FECHA_ACCIDENTE" as "AC_FECHA_ACCIDENTE",
"ARENA2_ACCIDENTES"."HORA_ACCIDENTE" as "AC_HORA_ACCIDENTE",
"ARENA2_ACCIDENTES"."COD_PROVINCIA" as "AC_COD_PROVINCIA",
"ARENA2_ACCIDENTES"."COD_MUNICIPIO" as "AC_COD_MUNICIPIO",
"ARENA2_ACCIDENTES"."COD_POBLACION" as "AC_COD_POBLACION",
"ARENA2_ACCIDENTES"."ZONA" as "AC_ZONA",
"ARENA2_ACCIDENTES"."TIPO_VIA" as "AC_TIPO_VIA",
"ARENA2_ACCIDENTES"."TIPO_VIA_DGT" as "AC_TIPO_VIA_DGT",
"ARENA2_ACCIDENTES"."CARRETERA" as "AC_CARRETERA",
"ARENA2_ACCIDENTES"."CARRETERA_DGT" as "AC_CARRETERA_DGT",
"ARENA2_ACCIDENTES"."KM" as "AC_KM",
"ARENA2_ACCIDENTES"."TITULARIDAD_VIA" as "AC_TITULARIDAD_VIA",
"ARENA2_ACCIDENTES"."TITULARIDAD_VIA_DGT" as "AC_TITULARIDAD_VIA_DGT",
"ARENA2_ACCIDENTES"."SENTIDO" as "AC_SENTIDO",
"ARENA2_ACCIDENTES"."CALLE_CODIGO" as "AC_CALLE_CODIGO",
"ARENA2_ACCIDENTES"."CALLE_NOMBRE" as "AC_CALLE_NOMBRE",
"ARENA2_ACCIDENTES"."CALLE_NUMERO" as "AC_CALLE_NUMERO",
"ARENA2_ACCIDENTES"."MAPAY" as "AC_MAPAY",
"ARENA2_ACCIDENTES"."MAPAX" as "AC_MAPAX",
"ARENA2_ACCIDENTES"."NUDO" as "AC_NUDO",
"ARENA2_ACCIDENTES"."NUDO_INFO" as "AC_NUDO_INFO",
"ARENA2_ACCIDENTES"."CRUCE_CALLE" as "AC_CRUCE_CALLE",
"ARENA2_ACCIDENTES"."CRUCE_INE_CALLE" as "AC_CRUCE_INE_CALLE",
"ARENA2_ACCIDENTES"."TOTAL_VICTIMAS" as "AC_TOTAL_VICTIMAS",
"ARENA2_ACCIDENTES"."TOTAL_MUERTOS" as "AC_TOTAL_MUERTOS",
"ARENA2_ACCIDENTES"."TOTAL_GRAVES" as "AC_TOTAL_GRAVES",
"ARENA2_ACCIDENTES"."TOTAL_LEVES" as "AC_TOTAL_LEVES",
"ARENA2_ACCIDENTES"."TOTAL_ILESOS" as "AC_TOTAL_ILESOS",
"ARENA2_ACCIDENTES"."TOTAL_VEHICULOS" as "AC_TOTAL_VEHICULOS",
"ARENA2_ACCIDENTES"."TOTAL_CONDUCTORES" as "AC_TOTAL_CONDUCTORES",
"ARENA2_ACCIDENTES"."TOTAL_PASAJEROS" as "AC_TOTAL_PASAJEROS",
"ARENA2_ACCIDENTES"."TOTAL_PEATONES" as "AC_TOTAL_PEATONES",
"ARENA2_ACCIDENTES"."NUM_TURISMOS" as "AC_NUM_TURISMOS",
"ARENA2_ACCIDENTES"."NUM_FURGONETAS" as "AC_NUM_FURGONETAS",
"ARENA2_ACCIDENTES"."NUM_CAMIONES" as "AC_NUM_CAMIONES",
"ARENA2_ACCIDENTES"."NUM_AUTOBUSES" as "AC_NUM_AUTOBUSES",
"ARENA2_ACCIDENTES"."NUM_CICLOMOTORES" as "AC_NUM_CICLOMOTORES",
"ARENA2_ACCIDENTES"."NUM_MOTOCICLETAS" as "AC_NUM_MOTOCICLETAS",
"ARENA2_ACCIDENTES"."NUM_BICICLETAS" as "AC_NUM_BICICLETAS",
"ARENA2_ACCIDENTES"."NUM_OTROS_VEHI" as "AC_NUM_OTROS_VEHI",
"ARENA2_ACCIDENTES"."TIPO_ACC_SALIDA" as "AC_TIPO_ACC_SALIDA",
"ARENA2_ACCIDENTES"."TIPO_ACC_COLISION" as "AC_TIPO_ACC_COLISION",
"ARENA2_ACCIDENTES"."TIPO_ACC_ANIMAL" as "AC_TIPO_ACC_ANIMAL",
"ARENA2_ACCIDENTES"."SENTIDO_CONTRARIO" as "AC_SENTIDO_CONTRARIO",
"ARENA2_ACCIDENTES"."CONDICION_NIVEL_CIRCULA" as "AC_CONDICION_NIVEL_CIRCULA",
"ARENA2_ACCIDENTES"."INFLU_NIVEL_CIRC" as "AC_INFLU_NIVEL_CIRC",
"ARENA2_ACCIDENTES"."CONDICION_FIRME" as "AC_CONDICION_FIRME",
"ARENA2_ACCIDENTES"."INFLU_SUP_FIRME" as "AC_INFLU_SUP_FIRME",
"ARENA2_ACCIDENTES"."CONDICION_ILUMINACION" as "AC_CONDICION_ILUMINACION",
"ARENA2_ACCIDENTES"."INFLU_ILUMINACION" as "AC_INFLU_ILUMINACION",
"ARENA2_ACCIDENTES"."CONDICION_METEO" as "AC_CONDICION_METEO",
"ARENA2_ACCIDENTES"."INFLU_METEO" as "AC_INFLU_METEO",
"ARENA2_ACCIDENTES"."CONDICION_NIEBLA" as "AC_CONDICION_NIEBLA",
"ARENA2_ACCIDENTES"."CONDICION_VIENTO" as "AC_CONDICION_VIENTO",
"ARENA2_ACCIDENTES"."VISIB_RESTRINGIDA_POR" as "AC_VISIB_RESTRINGIDA_POR",
"ARENA2_ACCIDENTES"."INFLU_VISIBILIDAD" as "AC_INFLU_VISIBILIDAD",
"ARENA2_ACCIDENTES"."CARACT_FUNCIONAL_VIA" as "AC_CARACT_FUNCIONAL_VIA",
"ARENA2_ACCIDENTES"."VEL_GENERICA_SENYALIZADA" as "AC_VEL_GENERICA_SENYALIZADA",
"ARENA2_ACCIDENTES"."VELOCIDAD" as "AC_VELOCIDAD",
"ARENA2_ACCIDENTES"."SENTIDOS_VIA" as "AC_SENTIDOS_VIA",
"ARENA2_ACCIDENTES"."NUMERO_CALZADAS" as "AC_NUMERO_CALZADAS",
"ARENA2_ACCIDENTES"."CARRILES_APTOS_CIRC_ASC" as "AC_CARRILES_APTOS_CIRC_ASC",
"ARENA2_ACCIDENTES"."CARRILES_APTOS_CIRC_DESC" as "AC_CARRILES_APTOS_CIRC_DESC",
"ARENA2_ACCIDENTES"."ANCHURA_CARRIL" as "AC_ANCHURA_CARRIL",
"ARENA2_ACCIDENTES"."ARCEN" as "AC_ARCEN",
"ARENA2_ACCIDENTES"."ACERA" as "AC_ACERA",
"ARENA2_ACCIDENTES"."INFLU_ACERA" as "AC_INFLU_ACERA",
"ARENA2_ACCIDENTES"."ANCHURA_ACERA" as "AC_ANCHURA_ACERA",
"ARENA2_ACCIDENTES"."TRAZADO_PLANTA" as "AC_TRAZADO_PLANTA",
"ARENA2_ACCIDENTES"."TRAZADO_ALZADO" as "AC_TRAZADO_ALZADO",
"ARENA2_ACCIDENTES"."MARCAS_VIALES" as "AC_MARCAS_VIALES",
"ARENA2_ACCIDENTES"."DESCRIPCION" as "AC_DESCRIPCION",
"ARENA2_ACCIDENTES"."OBSERVACIONES" as "AC_OBSERVACIONES",
"ARENA2_ACCIDENTES"."INFLU_PRIORIDAD" as "AC_INFLU_PRIORIDAD",
"ARENA2_ACCIDENTES"."PRIORI_NORMA" as "AC_PRIORI_NORMA",
"ARENA2_ACCIDENTES"."PRIORI_AGENTE" as "AC_PRIORI_AGENTE",
"ARENA2_ACCIDENTES"."PRIORI_SEMAFORO" as "AC_PRIORI_SEMAFORO",
"ARENA2_ACCIDENTES"."PRIORI_VERT_STOP" as "AC_PRIORI_VERT_STOP",
"ARENA2_ACCIDENTES"."PRIORI_VERT_CEDA" as "AC_PRIORI_VERT_CEDA",
"ARENA2_ACCIDENTES"."PRIORI_HORIZ_STOP" as "AC_PRIORI_HORIZ_STOP",
"ARENA2_ACCIDENTES"."PRIORI_HORIZ_CEDA" as "AC_PRIORI_HORIZ_CEDA",
"ARENA2_ACCIDENTES"."PRIORI_MARCAS" as "AC_PRIORI_MARCAS",
"ARENA2_ACCIDENTES"."PRIORI_PEA_NO_ELEV" as "AC_PRIORI_PEA_NO_ELEV",
"ARENA2_ACCIDENTES"."PRIORI_PEA_ELEV" as "AC_PRIORI_PEA_ELEV",
"ARENA2_ACCIDENTES"."PRIORI_MARCA_CICLOS" as "AC_PRIORI_MARCA_CICLOS",
"ARENA2_ACCIDENTES"."PRIORI_CIRCUNSTANCIAL" as "AC_PRIORI_CIRCUNSTANCIAL",
"ARENA2_ACCIDENTES"."PRIORI_OTRA" as "AC_PRIORI_OTRA",
"ARENA2_ACCIDENTES"."EB_PANELES_DIRECCIONALES" as "AC_EB_PANELES_DIRECCIONALES",
"ARENA2_ACCIDENTES"."EB_HITOS_ARISTA" as "AC_EB_HITOS_ARISTA",
"ARENA2_ACCIDENTES"."EB_CAPTAFAROS" as "AC_EB_CAPTAFAROS",
"ARENA2_ACCIDENTES"."SEPARA_LINEA_LONG_SEPARACION" as "AC_SEPARA_LINEA_LONG_SEPARACION",
"ARENA2_ACCIDENTES"."SEPARA_CEBREADO" as "AC_SEPARA_CEBREADO",
"ARENA2_ACCIDENTES"."SEPARA_MEDIANA" as "AC_SEPARA_MEDIANA",
"ARENA2_ACCIDENTES"."SEPARA_BARRERA_SEGURIDAD" as "AC_SEPARA_BARRERA_SEGURIDAD",
"ARENA2_ACCIDENTES"."SEPARA_ZONA_PEATONAL" as "AC_SEPARA_ZONA_PEATONAL",
"ARENA2_ACCIDENTES"."SEPARA_OTRA_SEPARACION" as "AC_SEPARA_OTRA_SEPARACION",
"ARENA2_ACCIDENTES"."SEPARA_NINGUNA_SEPARACION" as "AC_SEPARA_NINGUNA_SEPARACION",
"ARENA2_ACCIDENTES"."BARRERA_SEG_LAT_ASC" as "AC_BARRERA_SEG_LAT_ASC",
"ARENA2_ACCIDENTES"."BARRERA_SEG_LAT_ASC_MOTO" as "AC_BARRERA_SEG_LAT_ASC_MOTO",
"ARENA2_ACCIDENTES"."BARRERA_SEG_LAT_DESC" as "AC_BARRERA_SEG_LAT_DESC",
"ARENA2_ACCIDENTES"."BARRERA_SEG_LAT_DESC_MOTO" as "AC_BARRERA_SEG_LAT_DESC_MOTO",
"ARENA2_ACCIDENTES"."BARRERA_SEG_MEDIANA_ASC" as "AC_BARRERA_SEG_MEDIANA_ASC",
"ARENA2_ACCIDENTES"."BARRERA_SEG_MEDIANA_ASC_MOTO" as "AC_BARRERA_SEG_MEDIANA_ASC_MOTO",
"ARENA2_ACCIDENTES"."BARRERA_SEG_MEDIANA_DESC" as "AC_BARRERA_SEG_MEDIANA_DESC",
"ARENA2_ACCIDENTES"."BARRERA_SEG_MEDIANA_DESC_MOTO" as "AC_BARRERA_SEG_MEDIANA_DESC_MOTO",
"ARENA2_ACCIDENTES"."TRAMO_PUENTE" as "AC_TRAMO_PUENTE",
"ARENA2_ACCIDENTES"."TRAMO_TUNEL" as "AC_TRAMO_TUNEL",
"ARENA2_ACCIDENTES"."TRAMO_PASO" as "AC_TRAMO_PASO",
"ARENA2_ACCIDENTES"."TRAMO_ESTRECHA" as "AC_TRAMO_ESTRECHA",
"ARENA2_ACCIDENTES"."TRAMO_RESALTOS" as "AC_TRAMO_RESALTOS",
"ARENA2_ACCIDENTES"."TRAMO_BADEN" as "AC_TRAMO_BADEN",
"ARENA2_ACCIDENTES"."TRAMO_APARTADERO" as "AC_TRAMO_APARTADERO",
"ARENA2_ACCIDENTES"."TRAMO_NINGUNA" as "AC_TRAMO_NINGUNA",
"ARENA2_ACCIDENTES"."INFLU_MARGEN" as "AC_INFLU_MARGEN",
"ARENA2_ACCIDENTES"."MARGEN_DESPEJADO" as "AC_MARGEN_DESPEJADO",
"ARENA2_ACCIDENTES"."MARGEN_ARBOLES" as "AC_MARGEN_ARBOLES",
"ARENA2_ACCIDENTES"."MARGEN_OTROS_NATURALES" as "AC_MARGEN_OTROS_NATURALES",
"ARENA2_ACCIDENTES"."MARGEN_EDIFICIOS" as "AC_MARGEN_EDIFICIOS",
"ARENA2_ACCIDENTES"."MARGEN_POSTES" as "AC_MARGEN_POSTES",
"ARENA2_ACCIDENTES"."MARGEN_PUBLICIDAD" as "AC_MARGEN_PUBLICIDAD",
"ARENA2_ACCIDENTES"."MARGEN_OTROS_ARTIFICIALES" as "AC_MARGEN_OTROS_ARTIFICIALES",
"ARENA2_ACCIDENTES"."MARGEN_OTROS_OBSTACULOS" as "AC_MARGEN_OTROS_OBSTACULOS",
"ARENA2_ACCIDENTES"."MARGEN_DESC" as "AC_MARGEN_DESC",
"ARENA2_ACCIDENTES"."INFLU_CIRCUNS_ESP" as "AC_INFLU_CIRCUNS_ESP",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_NINGUNA" as "AC_CIRCUNS_ESP_NINGUNA",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_CONOS" as "AC_CIRCUNS_ESP_CONOS",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_ZANJA" as "AC_CIRCUNS_ESP_ZANJA",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_TAPA" as "AC_CIRCUNS_ESP_TAPA",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_OBRAS" as "AC_CIRCUNS_ESP_OBRAS",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_OBSTACULO" as "AC_CIRCUNS_ESP_OBSTACULO",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_DESPREND" as "AC_CIRCUNS_ESP_DESPREND",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_ESCALON" as "AC_CIRCUNS_ESP_ESCALON",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_FBACHES" as "AC_CIRCUNS_ESP_FBACHES",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_FDETERIORADO" as "AC_CIRCUNS_ESP_FDETERIORADO",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_OTRAS" as "AC_CIRCUNS_ESP_OTRAS",
"ARENA2_ACCIDENTES"."CIRCUNS_ESP_DESC" as "AC_CIRCUNS_ESP_DESC",
"ARENA2_ACCIDENTES"."INFLU_DELIM_CALZADA" as "AC_INFLU_DELIM_CALZADA",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_BORDILLO" as "AC_DELIM_CALZADA_BORDILLO",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_VALLAS" as "AC_DELIM_CALZADA_VALLAS",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_SETOS" as "AC_DELIM_CALZADA_SETOS",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_MARCAS" as "AC_DELIM_CALZADA_MARCAS",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_BARRERA" as "AC_DELIM_CALZADA_BARRERA",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_ISLETA" as "AC_DELIM_CALZADA_ISLETA",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_PEATONAL" as "AC_DELIM_CALZADA_PEATONAL",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_OTRA" as "AC_DELIM_CALZADA_OTRA",
"ARENA2_ACCIDENTES"."DELIM_CALZADA_SIN_DELIM" as "AC_DELIM_CALZADA_SIN_DELIM",
"ARENA2_ACCIDENTES"."FC_CON_DISTRAIDA" as "AC_FC_CON_DISTRAIDA",
"ARENA2_ACCIDENTES"."FC_VEL_INADECUADA" as "AC_FC_VEL_INADECUADA",
"ARENA2_ACCIDENTES"."FC_PRIORIDAD" as "AC_FC_PRIORIDAD",
"ARENA2_ACCIDENTES"."FC_SEGURIDAD" as "AC_FC_SEGURIDAD",
"ARENA2_ACCIDENTES"."FC_ADELANTAMIENTO" as "AC_FC_ADELANTAMIENTO",
"ARENA2_ACCIDENTES"."FC_GIRO" as "AC_FC_GIRO",
"ARENA2_ACCIDENTES"."FC_CON_NEGLIGENTE" as "AC_FC_CON_NEGLIGENTE",
"ARENA2_ACCIDENTES"."FC_CON_TEMERARIA" as "AC_FC_CON_TEMERARIA",
"ARENA2_ACCIDENTES"."FC_IRRUPCION_ANIMAL" as "AC_FC_IRRUPCION_ANIMAL",
"ARENA2_ACCIDENTES"."FC_IRRUPCION_PEATON" as "AC_FC_IRRUPCION_PEATON",
"ARENA2_ACCIDENTES"."FC_ALCOHOL" as "AC_FC_ALCOHOL",
"ARENA2_ACCIDENTES"."FC_DROGAS" as "AC_FC_DROGAS",
"ARENA2_ACCIDENTES"."FC_ESTADO_VIA" as "AC_FC_ESTADO_VIA",
"ARENA2_ACCIDENTES"."FC_METEORO" as "AC_FC_METEORO",
"ARENA2_ACCIDENTES"."FC_CANSANCIO" as "AC_FC_CANSANCIO",
"ARENA2_ACCIDENTES"."FC_INEXPERIENCIA" as "AC_FC_INEXPERIENCIA",
"ARENA2_ACCIDENTES"."FC_AVERIA" as "AC_FC_AVERIA",
"ARENA2_ACCIDENTES"."FC_OBRAS" as "AC_FC_OBRAS",
"ARENA2_ACCIDENTES"."FC_MAL_ESTADO_VEHI" as "AC_FC_MAL_ESTADO_VEHI",
"ARENA2_ACCIDENTES"."FC_ENFERMEDAD" as "AC_FC_ENFERMEDAD",
"ARENA2_ACCIDENTES"."FC_SENYALIZACION" as "AC_FC_SENYALIZACION",
"ARENA2_ACCIDENTES"."FC_OBSTACULO" as "AC_FC_OBSTACULO",
"ARENA2_ACCIDENTES"."FC_OTRO_FACTOR" as "AC_FC_OTRO_FACTOR",



-- "ARENA2_VEHICULOS"."LID_VEHICULO" as "LID_VEHICULO",
-- "ARENA2_VEHICULOS"."ID_ACCIDENTE" as "ID_ACCIDENTE",
"ARENA2_VEHICULOS"."ID_VEHICULO" as "ID_VEHICULO",

"ARENA2_VEHICULOS"."SIN_CONDUCTOR" as "VE_SIN_CONDUCTOR",
"ARENA2_VEHICULOS"."LID_CONDUCTOR" as "VE_LID_CONDUCTOR",
"ARENA2_VEHICULOS"."FECHA_MATRICULACION" as "VE_FECHA_MATRICULACION",
"ARENA2_VEHICULOS"."NACIONALIDAD" as "VE_NACIONALIDAD",
"ARENA2_VEHICULOS"."TIPO_VEHICULO" as "VE_TIPO_VEHICULO",
"ARENA2_VEHICULOS"."MMA" as "VE_MMA",
"ARENA2_VEHICULOS"."MARCA_NOMBRE" as "VE_MARCA_NOMBRE",
"ARENA2_VEHICULOS"."MODELO" as "VE_MODELO",
"ARENA2_VEHICULOS"."ITV" as "VE_ITV",
"ARENA2_VEHICULOS"."SEGURO" as "VE_SEGURO",
"ARENA2_VEHICULOS"."NUM_OCUPANTES" as "VE_NUM_OCUPANTES",
"ARENA2_VEHICULOS"."VEHICULO_ADAPTADO" as "VE_VEHICULO_ADAPTADO",
"ARENA2_VEHICULOS"."TRANSPORTE_ESPECIAL" as "VE_TRANSPORTE_ESPECIAL",
"ARENA2_VEHICULOS"."FUGADO" as "VE_FUGADO",
"ARENA2_VEHICULOS"."INCENDIADO" as "VE_INCENDIADO",
"ARENA2_VEHICULOS"."MP" as "VE_MP",
"ARENA2_VEHICULOS"."MP_NUMERO_ONU" as "VE_MP_NUMERO_ONU",
"ARENA2_VEHICULOS"."DANYOS" as "VE_DANYOS",
"ARENA2_VEHICULOS"."REMOLQUE" as "VE_REMOLQUE",
"ARENA2_VEHICULOS"."SEMIREMOLQUE" as "VE_SEMIREMOLQUE",
"ARENA2_VEHICULOS"."CARAVANA" as "VE_CARAVANA",
"ARENA2_VEHICULOS"."REMOLQUE_OTROS" as "VE_REMOLQUE_OTROS",
"ARENA2_VEHICULOS"."POS_VIA" as "VE_POS_VIA",
"ARENA2_VEHICULOS"."APROXIMACION_NUDO" as "VE_APROXIMACION_NUDO",
"ARENA2_VEHICULOS"."SENTIDO_CIRCULACION" as "VE_SENTIDO_CIRCULACION",
"ARENA2_VEHICULOS"."LUGAR_CIRCULABA" as "VE_LUGAR_CIRCULABA",
"ARENA2_VEHICULOS"."FACT_LUGAR_CIRCULA" as "VE_FACT_LUGAR_CIRCULA",
"ARENA2_VEHICULOS"."TACOGRAFO_DISCO" as "VE_TACOGRAFO_DISCO",
"ARENA2_VEHICULOS"."TACOGRAFO_LECTURA" as "VE_TACOGRAFO_LECTURA",
"ARENA2_VEHICULOS"."DESCANSO_DIARIO" as "VE_DESCANSO_DIARIO",
"ARENA2_VEHICULOS"."HORAS_COND_CONTINU_SUP" as "VE_HORAS_COND_CONTINU_SUP",
"ARENA2_VEHICULOS"."HORAS_COND_DIARIA_SUP" as "VE_HORAS_COND_DIARIA_SUP",
"ARENA2_VEHICULOS"."HORAS_COND_CONTINUADAS_H" as "VE_HORAS_COND_CONTINUADAS_H",
"ARENA2_VEHICULOS"."HORAS_COND_CONTINUADAS_MIN" as "VE_HORAS_COND_CONTINUADAS_MIN",
"ARENA2_VEHICULOS"."FACT_ANOMALIAS_PREVIAS" as "VE_FACT_ANOMALIAS_PREVIAS",
"ARENA2_VEHICULOS"."ANOMALIAS_NINGUNA" as "VE_ANOMALIAS_NINGUNA",
"ARENA2_VEHICULOS"."ANOMALIAS_NEUMATICOS" as "VE_ANOMALIAS_NEUMATICOS",
"ARENA2_VEHICULOS"."ANOMALIAS_REVENTON" as "VE_ANOMALIAS_REVENTON",
"ARENA2_VEHICULOS"."ANOMALIAS_DIRECCION" as "VE_ANOMALIAS_DIRECCION",
"ARENA2_VEHICULOS"."ANOMALIAS_FRENOS" as "VE_ANOMALIAS_FRENOS",
"ARENA2_VEHICULOS"."ANOMALIAS_OTRAS" as "VE_ANOMALIAS_OTRAS",
"ARENA2_VEHICULOS"."ANOMALIAS_OTRA" as "VE_ANOMALIAS_OTRA",
"ARENA2_VEHICULOS"."AIRBAG_COND" as "VE_AIRBAG_COND",
"ARENA2_VEHICULOS"."AIRBAG_PAS_DEL" as "VE_AIRBAG_PAS_DEL",
"ARENA2_VEHICULOS"."AIRBAG_ROD_IZDA" as "VE_AIRBAG_ROD_IZDA",
"ARENA2_VEHICULOS"."AIRBAG_ROD_DCHA" as "VE_AIRBAG_ROD_DCHA",
"ARENA2_VEHICULOS"."AIRBAG_LAT_DEL_IZDA" as "VE_AIRBAG_LAT_DEL_IZDA",
"ARENA2_VEHICULOS"."AIRBAG_LAT_DEL_DCHA" as "VE_AIRBAG_LAT_DEL_DCHA",
"ARENA2_VEHICULOS"."AIRBAG_CORT_DEL_IZDA" as "VE_AIRBAG_CORT_DEL_IZDA",
"ARENA2_VEHICULOS"."AIRBAG_CORT_DEL_DCHA" as "VE_AIRBAG_CORT_DEL_DCHA",
"ARENA2_VEHICULOS"."AIRBAG_LAT_TRAS_IZDA" as "VE_AIRBAG_LAT_TRAS_IZDA",
"ARENA2_VEHICULOS"."AIRBAG_LAT_TRAS_DCHA" as "VE_AIRBAG_LAT_TRAS_DCHA",
"ARENA2_VEHICULOS"."AIRBAG_CORT_TRAS_IZDA" as "VE_AIRBAG_CORT_TRAS_IZDA",
"ARENA2_VEHICULOS"."AIRBAG_CORT_TRAS_DCHA" as "VE_AIRBAG_CORT_TRAS_DCHA",
"ARENA2_VEHICULOS"."AIRBAG_OTROS" as "VE_AIRBAG_OTROS",
"ARENA2_VEHICULOS"."AIRBAG_DESCONOCIDO" as "VE_AIRBAG_DESCONOCIDO",


-- "ARENA2_CONDUCTORES"."LID_CONDUCTOR" as "LID_CONDUCTOR",
-- "ARENA2_CONDUCTORES"."ID_ACCIDENTE" as "ID_ACCIDENTE",
-- "ARENA2_CONDUCTORES"."LID_VEHICULO" as "LID_VEHICULO",
-- "ARENA2_CONDUCTORES"."ID_VEHICULO" as "ID_VEHICULO",
"ARENA2_CONDUCTORES"."POSIBLE_RESPONSABLE" as "CO_POSIBLE_RESPONSABLE",
"ARENA2_CONDUCTORES"."FECHA_NACIMIENTO" as "CO_FECHA_NACIMIENTO",
"ARENA2_CONDUCTORES"."SEXO" as "CO_SEXO",
"ARENA2_CONDUCTORES"."NACIONALIDAD" as "CO_NACIONALIDAD",
"ARENA2_CONDUCTORES"."PAIS_RESIDENCIA" as "CO_PAIS_RESIDENCIA",
"ARENA2_CONDUCTORES"."PROVINCIA_RESIDENCIA" as "CO_PROVINCIA_RESIDENCIA",
"ARENA2_CONDUCTORES"."MUNICIPIO_RESIDENCIA" as "CO_MUNICIPIO_RESIDENCIA",
"ARENA2_CONDUCTORES"."ASISTENCIA_SANITARIA" as "CO_ASISTENCIA_SANITARIA",
"ARENA2_CONDUCTORES"."INFLU_FACT_ATENCION" as "CO_INFLU_FACT_ATENCION",
"ARENA2_CONDUCTORES"."FACTORES_ATENCION" as "CO_FACTORES_ATENCION",
"ARENA2_CONDUCTORES"."INFLU_PRES_ERROR" as "CO_INFLU_PRES_ERROR",
"ARENA2_CONDUCTORES"."PRESUNTOS_ERRORES" as "CO_PRESUNTOS_ERRORES",
"ARENA2_CONDUCTORES"."CARACT_PERMISO" as "CO_CARACT_PERMISO",
"ARENA2_CONDUCTORES"."CLASE_PERMISO" as "CO_CLASE_PERMISO",
"ARENA2_CONDUCTORES"."FECHA_PERMISO" as "CO_FECHA_PERMISO",
"ARENA2_CONDUCTORES"."MOTIVO_DESPLAZAMIENTO" as "CO_MOTIVO_DESPLAZAMIENTO",
"ARENA2_CONDUCTORES"."DESPLAZAMIENTO_PREVISTO" as "CO_DESPLAZAMIENTO_PREVISTO",
"ARENA2_CONDUCTORES"."ACC_SEG_CINTURON" as "CO_ACC_SEG_CINTURON",
"ARENA2_CONDUCTORES"."ACC_SEG_CASCO" as "CO_ACC_SEG_CASCO",
"ARENA2_CONDUCTORES"."ACC_SEG_BRAZOS" as "CO_ACC_SEG_BRAZOS",
"ARENA2_CONDUCTORES"."ACC_SEG_ESPALDA" as "CO_ACC_SEG_ESPALDA",
"ARENA2_CONDUCTORES"."ACC_SEG_TORSO" as "CO_ACC_SEG_TORSO",
"ARENA2_CONDUCTORES"."ACC_SEG_MANOS" as "CO_ACC_SEG_MANOS",
"ARENA2_CONDUCTORES"."ACC_SEG_PIERNAS" as "CO_ACC_SEG_PIERNAS",
"ARENA2_CONDUCTORES"."ACC_SEG_PIES" as "CO_ACC_SEG_PIES",
"ARENA2_CONDUCTORES"."ACC_SEG_PRENDA_REF" as "CO_ACC_SEG_PRENDA_REF",
"ARENA2_CONDUCTORES"."INFLU_ALCOHOL" as "CO_INFLU_ALCOHOL",
"ARENA2_CONDUCTORES"."PRUEBA_ALCOHOLEMIA" as "CO_PRUEBA_ALCOHOLEMIA",
"ARENA2_CONDUCTORES"."TASA_ALCOHOLEMIA1" as "CO_TASA_ALCOHOLEMIA1",
"ARENA2_CONDUCTORES"."TASA_ALCOHOLEMIA2" as "CO_TASA_ALCOHOLEMIA2",
"ARENA2_CONDUCTORES"."PRUEBA_ALC_SANGRE" as "CO_PRUEBA_ALC_SANGRE",
"ARENA2_CONDUCTORES"."SIGNOS_INFLU_ALCOHOL" as "CO_SIGNOS_INFLU_ALCOHOL",
"ARENA2_CONDUCTORES"."INFLU_DROGAS" as "CO_INFLU_DROGAS",
"ARENA2_CONDUCTORES"."PRUEBA_DROGAS" as "CO_PRUEBA_DROGAS",
"ARENA2_CONDUCTORES"."AMP" as "CO_AMP",
"ARENA2_CONDUCTORES"."CONFIRMADO_AMP" as "CO_CONFIRMADO_AMP",
"ARENA2_CONDUCTORES"."BDZ" as "CO_BDZ",
"ARENA2_CONDUCTORES"."CONFIRMADO_BDZ" as "CO_CONFIRMADO_BDZ",
"ARENA2_CONDUCTORES"."COC" as "CO_COC",
"ARENA2_CONDUCTORES"."CONFIRMADO_COC" as "CO_CONFIRMADO_COC",
"ARENA2_CONDUCTORES"."THC" as "CO_THC",
"ARENA2_CONDUCTORES"."CONFIRMADO_THC" as "CO_CONFIRMADO_THC",
"ARENA2_CONDUCTORES"."METH" as "CO_METH",
"ARENA2_CONDUCTORES"."CONFIRMADO_METH" as "CO_CONFIRMADO_METH",
"ARENA2_CONDUCTORES"."OPI" as "CO_OPI",
"ARENA2_CONDUCTORES"."CONFIRMADO_OPI" as "CO_CONFIRMADO_OPI",
"ARENA2_CONDUCTORES"."OTRAS" as "CO_OTRAS",
"ARENA2_CONDUCTORES"."CONFIRMADO_OTRAS" as "CO_CONFIRMADO_OTRAS",
"ARENA2_CONDUCTORES"."SIGNOS_INFLU_DROGAS" as "CO_SIGNOS_INFLU_DROGAS",
"ARENA2_CONDUCTORES"."INFLU_PRES_INFRAC_COND" as "CO_INFLU_PRES_INFRAC_COND",
"ARENA2_CONDUCTORES"."PRES_INFRAC_COND" as "CO_PRES_INFRAC_COND",
"ARENA2_CONDUCTORES"."PRES_INFRAC_SIN_LUCES" as "CO_PRES_INFRAC_SIN_LUCES",
"ARENA2_CONDUCTORES"."PRES_INFRAC_SIN_TRIANGULO" as "CO_PRES_INFRAC_SIN_TRIANGULO",
"ARENA2_CONDUCTORES"."INFLU_PRES_INFRAC_VEL" as "CO_INFLU_PRES_INFRAC_VEL",
"ARENA2_CONDUCTORES"."PRES_INFRAC_VEL_COND" as "CO_PRES_INFRAC_VEL_COND",
"ARENA2_CONDUCTORES"."INFLU_OTRA_INFRAC" as "CO_INFLU_OTRA_INFRAC",
"ARENA2_CONDUCTORES"."OTRA_INFRAC_COND" as "CO_OTRA_INFRAC_COND",

-- "ARENA2_PASAJEROS"."LID_PASAJERO" as "LID_PASAJERO",
-- "ARENA2_PASAJEROS"."ID_ACCIDENTE" as "ID_ACCIDENTE",
-- "ARENA2_PASAJEROS"."LID_VEHICULO" as "LID_VEHICULO",
-- "ARENA2_PASAJEROS"."ID_VEHICULO" as "ID_VEHICULO",
"ARENA2_PASAJEROS"."ID_PASAJERO" as "ID_PASAJERO",

"ARENA2_PASAJEROS"."FECHA_NACIMIENTO" as "PA_FECHA_NACIMIENTO",
"ARENA2_PASAJEROS"."SEXO" as "PA_SEXO",
"ARENA2_PASAJEROS"."PAIS_RESIDENCIA" as "PA_PAIS_RESIDENCIA",
"ARENA2_PASAJEROS"."PROVINCIA_RESIDENCIA" as "PA_PROVINCIA_RESIDENCIA",
"ARENA2_PASAJEROS"."MUNICIPIO_RESIDENCIA" as "PA_MUNICIPIO_RESIDENCIA",
"ARENA2_PASAJEROS"."ASISTENCIA_SANITARIA" as "PA_ASISTENCIA_SANITARIA",
"ARENA2_PASAJEROS"."POSICION_VEHI" as "PA_POSICION_VEHI",
"ARENA2_PASAJEROS"."NINYO_EN_BRAZO" as "PA_NINYO_EN_BRAZO",
"ARENA2_PASAJEROS"."ACC_SEG_CINTURON" as "PA_ACC_SEG_CINTURON",
"ARENA2_PASAJEROS"."ACC_SEG_CASCO" as "PA_ACC_SEG_CASCO",
"ARENA2_PASAJEROS"."ACC_SEG_SIS_RETEN_INFANTIL" as "PA_ACC_SEG_SIS_RETEN_INFANTIL",
"ARENA2_PASAJEROS"."ACC_SEG_BRAZOS" as "PA_ACC_SEG_BRAZOS",
"ARENA2_PASAJEROS"."ACC_SEG_ESPALDA" as "PA_ACC_SEG_ESPALDA",
"ARENA2_PASAJEROS"."ACC_SEG_TORSO" as "PA_ACC_SEG_TORSO",
"ARENA2_PASAJEROS"."ACC_SEG_MANOS" as "PA_ACC_SEG_MANOS",
"ARENA2_PASAJEROS"."ACC_SEG_PIERNAS" as "PA_ACC_SEG_PIERNAS",
"ARENA2_PASAJEROS"."ACC_SEG_PIES" as "PA_ACC_SEG_PIES",
"ARENA2_PASAJEROS"."ACC_SEG_PRENDA_REF" as "PA_ACC_SEG_PRENDA_REF"


FROM ARENA2_ACCIDENTES 
LEFT JOIN ARENA2_VEHICULOS on ARENA2_ACCIDENTES.LID_ACCIDENTE = ARENA2_VEHICULOS.ID_ACCIDENTE 
LEFT JOIN ARENA2_CONDUCTORES on ARENA2_VEHICULOS.LID_VEHICULO = ARENA2_CONDUCTORES.LID_VEHICULO
LEFT JOIN ARENA2_PASAJEROS on ARENA2_VEHICULOS.LID_VEHICULO = ARENA2_PASAJEROS.LID_VEHICULO 

ORDER BY 
  "ARENA2_ACCIDENTES"."COD_INFORME", 
  "ARENA2_ACCIDENTES"."ID_ACCIDENTE",
  "ARENA2_VEHICULOS"."LID_VEHICULO",
  "ARENA2_PASAJEROS"."LID_PASAJERO"
