Shame on me. I had a mistake in my previous pos. Thanks to [info]xaprb for pointing this out.

I misplaced quote marks in my second query.

Instead of
date BETWEEN '2008-01-01 12:00:00.000' AND '2008-01-14 12:00:00.000' AND accomodation=1

I wrote this:
date BETWEEN '2008-01-01 12:00:00.000' AND '2008-01-14 12:00:00.000 AND accomodation=1'

Note the last quote mark after accomodation=1

:)