insert into mig_pres_catedras
select c.id as codigo,
    cd.id_sede,
    0 as departamento,
    c.id_materia as asignatura,
    --(select COALESCE(df.id_resolucion,df.id_ordenanza) from cargos_funciones.docentes_funciones df where c.id=df.id_comision limit 1) as ordenanza,
    r.numero as ordenanza,
    horas_catedra as carga_horaria,
    cpm.anio_cursado as anio,
    case c.id_modalidad
        when 1 then 'P'
        when 2 then 'SP'
    end as modalidad,

    cp.id_carrera,
    horas_catedra as total_horas,
    0 as total_clases,
    case c.id_periodo_academico
        when 1 then '1er Cuatrimestre'
        when 2 then '2do Cuatrimestre'
        when 3 then 'Anual'
        when 4 then 'Semanal'
    end as periodo_lectivo,
    c.anio_academico as ciclo_lectivo,
    0 as pasado
from cargos_funciones.comisiones c
inner join cargos_funciones.carreras_dictadas cd on (c.id_carrera_dictada=cd.id)
inner join carreras.carreras_planes cp on (cd.id_carrera_plan = cp.id)
left outer join carreras.carreras_planes_materias cpm on (cpm.id_carrera_plan = cd.id_carrera_plan and cpm.id_materia = c.id_materia)
left outer join actos_administrativos.resoluciones r on (select COALESCE(df.id_resolucion,df.id_ordenanza) from cargos_funciones.docentes_funciones df where c.id=df.id_comision limit 1)=r.id
where c.anio_academico = 2017 and c.id_periodo_academico = 2