Pb de requete mysql

Bonjour,

je ne suis pas sure d'etre au bon endroit ce code ne marche pas je pense que ca cloche au niveau des dates je ne sais pas comment les ecrire pour trouver une disponibilite:

SELECT hotel.hotel_name, hotel.city, room.room_ID, room.room_name, room.price_PD as availability
FROM hotel, room, reservation
WHERE hotel.hotel_ID = room.hotel_ID
and room.room_ID = reservation.room_ID

and hotel.country like 'spain'
and room.max_of_guest >=2
and room.no_of_bed = 1
and reservation.start_date not in ( 2009/03/01, 2009/03/02, 2009/03/03, 2009/03/04, 2009/03/05 , 2009/03/06, 2009/03/07, 2009/03/08)
and reservation.end_date not in ( 2009/03/01, 2009/03/02, 2009/03/03, 2009/03/04, 2009/03/05 , 2009/03/06, 2009/03/07, 2009/03/08)
and room.smoking_allowed like 'yes';

Quelqu'un peu m'aider?