select a.*, s.*, s.id as id_sesion, s.foto as foto_sesion, a.foto as foto_evento, e.nombreeu as espacio, l.nombreeu 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-04-16 01:01:15' and s.fecha like ? and idCategoria IN (?) order by a.prioridad desc, s.fecha asc, s.hora asc