Albergue de REDES - - INTRANET - Asignación
COD
ENTRA
SALE
APARTAMENTO
CUANTOS SON
CUNAS
OBSERVACIONES
205
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
206
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
207
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
208
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
209
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
210
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
211
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
212
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
213
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
214
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
215
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
216
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
217
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
218
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
219
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
220
Apartamentos libres:
select * from asignaciones where id_apart = 111 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 111 (2 personas)
select * from asignaciones where id_apart = 112 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 112 (2 personas)
select * from asignaciones where id_apart = 113 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 113 (6 personas)
select * from asignaciones where id_apart = 114 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 114 (6 personas)
select * from asignaciones where id_apart = 121 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 121 (5 personas)
select * from asignaciones where id_apart = 122 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 122 (5 personas)
select * from asignaciones where id_apart = 123 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 123 (5 personas)
select * from asignaciones where id_apart = 124 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 124 (5 personas)
select * from asignaciones where id_apart = 211 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 211 (6 personas)
select * from asignaciones where id_apart = 212 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 212 (6 personas)
select * from asignaciones where id_apart = 213 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 213 (6 personas)
select * from asignaciones where id_apart = 214 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 214 (6 personas)
select * from asignaciones where id_apart = 221 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 221 (5 personas)
select * from asignaciones where id_apart = 222 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 222 (5 personas)
select * from asignaciones where id_apart = 223 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 223 (5 personas)
select * from asignaciones where id_apart = 224 and id_reserva!=46 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
apt. 224 (5 personas)
SON:
Apartamentos libres:
select * from asignaciones where id_apart = 111 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 112 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 113 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 114 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 121 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 122 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 123 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 124 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 211 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 212 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 213 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 214 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 221 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 222 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 223 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )select * from asignaciones where id_apart = 224 and ( ('2025-04-08' >= fecha_in and '2025-04-08' < fecha_out) or ('2025-04-08' < fecha_in and '2025-04-11' > fecha_in ) )
SON:
CERRAR