{"grupos":[],"numGrupos":0,"ciclos":null,"periodicidadDefault":null,"SgroupList":null,"FSgroupList":null,"groupList":null,"Sactivado":false,"FSactivado":true,"baseEncuestaActivado":false,"query":"\n SELECT DISTINCT\n cs.identifier AS 'matricula',\n u2.id AS 'grupoID',\n u2.name AS 'grupoNombre',\n u2.code AS 'grupoCodigo',\n ct.name AS 'cicloNombre',\n ct.code AS 'cicloCodigo',\n ct2.name AS 'cicloNombre2',\n ct2.code AS 'cicloCodigo2',\n cs2.section_name AS 'materiaNombre',\n cs2.section_code AS 'materiaCodigo',\n cs2.id AS 'materiaID',\n cs3.identifier AS 'nomina',\n cs3.firstname AS 'profesorNombre',\n cs3.lastname AS 'profesorApellido',\n cs4.identifier AS 'nomina2',\n cs4.firstname AS 'profesorNombre2',\n cs4.lastname AS 'profesorApellido2',\n cc.name AS 'materiaNombre2',\n cc.code AS 'materiaCodigo2',\n cc2.name AS 'materiaNombre3',\n cc2.code AS 'materiaCodigo3'\n FROM UMM_conector_CNtoBS_prd.dbo.cn_student cs\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.api_lms_section_group_section_enrol u1 ON cs.id = u1.sis_user_id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.api_lms_section_group_section_calculated u2 ON u2.id=u1.section_calculated_id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.api_lms_section_group u3 ON u3.id = u2.section_group_id AND u3.shift_id = 9\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.api_lms_section_group_enrol u4 ON u4.sis_user_id = u1.sis_user_id AND u4.source_id = u3.id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.cn_class_section cs2 ON cs2.id = u4.sis_section_id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.cn_staff cs3 ON cs3.id = u2.staff_id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.cn_course cc ON cc.id=u3.master_course_id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.cn_course cc2 ON cc2.id=cs2.course_id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.cn_staff cs4 ON cs4.id = cs2.instructor_id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.cn_term ct ON ct.id = u3.term_id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.cn_class_section_term cst ON cst.class_section_id = cs2.id\n LEFT JOIN UMM_conector_CNtoBS_prd.dbo.cn_term ct2 ON ct2.id = cst.term_id\n WHERE u3.id IS NOT NULL\n AND cs3.identifier NOT IN ('m9504')\n AND cs4.identifier NOT IN ('m9504')\n AND cs.id = 101957\n AND ct.code = '2026T1'\n ","query_2":"SELECT * FROM cd_encuesta WHERE activo = 1 AND tipo = 2 AND ciclo = 351 AND current_timestamp() BETWEEN inicio AND fin LIMIT 1","prueba":false}