CIISTI 2026

Agenda

-------SELECT * FROM (SELECT 'A' as tipo,A.id as ID,HoraInicio,HoraFin,A.Nombre,idPersona,Urlvideo as UrlVideo,concat(C.Nombre) as Ponente,Cupo,Fecha, Lugar, '' from Agenda A join expositor C on A.idPersona=C.id where fecha='2026-11-09' UNION all SELECT If(Categoria=1,'Conferencia','Ponencia') as tipo,A.id_conferencia as ID,hora_inicio,hora_fin, A.nombre,A.id_conferencista as idPonente, urlVideo as UrlVideo, concat(C.Nombre) as Ponente,cupo,fecha, lugar_conf as Lugar, Categoria from conferencia A join expositor C on A.id_conferencista=C.id where fecha='2026-11-09' UNION ALL SELECT 'Taller' as tipo,A.id as ID,hora_inicio,hora_fin, A.nombre,A.id_tallerista as idPonente, UrlVideo, concat(E.Nombre) as Ponente,cupo,fecha, lugar as Lugar,'' from taller A join expositor E on A.id_tallerista=E.id where fecha='2026-11-09' UNION ALL SELECT 'Panel' as tipo,A.id as ID,HoraInicio,HoraFin, A.Titulo,'IdPonente' as idPonente, UrlVideo, 'Ponente' as Ponente,Cupo,Fecha,Lugar,'' from paneles A where fecha='2026-11-09' ) as T order by HoraInicio-----------------SELECT * FROM (SELECT 'A' as tipo,A.id as ID,HoraInicio,HoraFin,A.Nombre,idPersona,Urlvideo as UrlVideo,concat(C.Nombre) as Ponente,Cupo,Fecha, Lugar, '' from Agenda A join expositor C on A.idPersona=C.id where fecha='2026-11-10' UNION all SELECT If(Categoria=1,'Conferencia','Ponencia') as tipo,A.id_conferencia as ID,hora_inicio,hora_fin, A.nombre,A.id_conferencista as idPonente, urlVideo as UrlVideo, concat(C.Nombre) as Ponente,cupo,fecha, lugar_conf as Lugar, Categoria from conferencia A join expositor C on A.id_conferencista=C.id where fecha='2026-11-10' UNION ALL SELECT 'Taller' as tipo,A.id as ID,hora_inicio,hora_fin, A.nombre,A.id_tallerista as idPonente, UrlVideo, concat(E.Nombre) as Ponente,cupo,fecha, lugar as Lugar,'' from taller A join expositor E on A.id_tallerista=E.id where fecha='2026-11-10' UNION ALL SELECT 'Panel' as tipo,A.id as ID,HoraInicio,HoraFin, A.Titulo,'IdPonente' as idPonente, UrlVideo, 'Ponente' as Ponente,Cupo,Fecha,Lugar,'' from paneles A where fecha='2026-11-10' ) as T order by HoraInicio-----------------SELECT * FROM (SELECT 'A' as tipo,A.id as ID,HoraInicio,HoraFin,A.Nombre,idPersona,Urlvideo as UrlVideo,concat(C.Nombre) as Ponente,Cupo,Fecha, Lugar, '' from Agenda A join expositor C on A.idPersona=C.id where fecha='2026-11-11' UNION all SELECT If(Categoria=1,'Conferencia','Ponencia') as tipo,A.id_conferencia as ID,hora_inicio,hora_fin, A.nombre,A.id_conferencista as idPonente, urlVideo as UrlVideo, concat(C.Nombre) as Ponente,cupo,fecha, lugar_conf as Lugar, Categoria from conferencia A join expositor C on A.id_conferencista=C.id where fecha='2026-11-11' UNION ALL SELECT 'Taller' as tipo,A.id as ID,hora_inicio,hora_fin, A.nombre,A.id_tallerista as idPonente, UrlVideo, concat(E.Nombre) as Ponente,cupo,fecha, lugar as Lugar,'' from taller A join expositor E on A.id_tallerista=E.id where fecha='2026-11-11' UNION ALL SELECT 'Panel' as tipo,A.id as ID,HoraInicio,HoraFin, A.Titulo,'IdPonente' as idPonente, UrlVideo, 'Ponente' as Ponente,Cupo,Fecha,Lugar,'' from paneles A where fecha='2026-11-11' ) as T order by HoraInicio----------

• Día 1(Mon 09,Nov)
• Día 2(Tue 10,Nov)
• Día 3(Wed 11,Nov)