I have this reservation request:
rental car for 2 days starting from 13.02.2016 - 09:00h to 15.02.2016 09:00h

Before confirming availability I want to check my database which cars will be busy / already reserved.

I make this query:

```
select id,modelname from res_reservations 
where resnumber!="9915" and datestart > now() and 
(datestart BETWEEN "2016-02-13 09:00:00" AND "2016-02-15 09:00:00" or
dateend BETWEEN "2016-02-13 09:00:00" AND "2016-02-15 09:00:00") 
order by id ASC 

```

in the database res\_reservations I have the following records:

```
#id     #modelname      #datestart              #dateend
9912    Volvo           2016-02-25 11:00:00     2016-02-29 09:30:00
9911    Renault         2016-02-12 19:15:00     2016-02-24 12:00:00
9913    Opel            2016-02-16 12:00:00     2016-02-18 12:00:00

```

My query returns no cars are busy for this period but this is not valid because id #9911 will be reserved between 2016-02-12 19:15:00 - 2016-02-24 12:00:00

How to get all cars that are already booked for the period.

Thank you for any help and suggestion.

Just to clarify, I have a serious reason to search the database for reserved cars, but not for the free ones..