select a.*, s.*, s.id as id_sesion, s.foto as foto_sesion, a.foto as foto_evento, e.nombrees as espacio, l.nombrees as localidad, e.mostrar_localidad from (((agenda as a inner join sesion as s on a.id=s.id_agenda) inner join agendaespacio as e on e.id=s.idEspacio) left join localidad as l on l.id=e.idLocalidad) where a.activo and activacion <= '2026-05-19 15:28:20' and s.fecha like ? and idCategoria IN (?) order by a.prioridad desc, s.fecha asc, s.hora asc