Laravel Eloquent with Subselect and Advanced Where

subselect.php

<?php
 DB::table('rooms')
	->whereNotIn('room_id', function($query)
	 {
		$query->select('room_id')
			->from(with(new Booking)->getTable())
			->where(function($query)
			{
				$query->where('time_out', '<', '2012-09-14T18:00')
					->orWhere('time_in', '>', '2012-09-21T09:00');
			});
	 })
	->orderBy('room_id')
	->get();

You can leave this in your route.php to see the Query

Event::listen('illuminate.query', function()
{
echo '<pre>';
var_dump(func_get_args());
echo '</pre>';
});