Re: Help with heavy query

[Hector Tino]

i try this:

SELECT
count(H.tipoHabitacion) AS total
FROM
AviratoPMS.habitaciones H
INNER JOIN
AviratoPMS.bloqueoHabitaciones B ON (H.idHabitacion != B.idHabitacion
AND H.idhospital = 1
AND H.online = '1'
AND H.tipoHabitacion = 'CUADRUPLE'
AND B.idhospital = 1
AND NOT (DATE(B.fechaInicial) >= DATE('4-10-2014')
OR DATE(B.fechaFinal) <= DATE('3-10-2013')))
INNER JOIN
AviratoPMS.reservas R ON (H.idHabitacion != R.idHabitacion
AND R.idhospital = 1
AND R.estado not in ('Eliminada' , 'No Show', 'Reserva cancelada')
AND NOT (DATE(R.fechaEntrada) >= DATE('4-10-2014')
OR DATE(R.fechaSalida) <= DATE('3-10-2013')))
;



But don´t work for me :S Help Please