select * from agenda where activo and nombrees<>"" and (
exists(select * from sesion where fecha like ? and fecha>="2024-05-15" and sesion.id_agenda=agenda.id)
or(
not exists(select * from sesion where sesion.id_agenda=agenda.id) and
DATE_FORMAT(fecha, "%Y-%m")<=? and DATE_FORMAT(fechaF, "%Y-%m")>=? and fechaF>="2024-05-15"
)
) and idCategoria IN (?) order by fecha asc, hora asc
No hay eventos programados.