有人能帮我把这个有说服力的查询转换成sql查询吗，因为我正在研究这段代码。我很难理解这段代码是什么，因为我是一个新的口才，但我有一些sql的经验。

$checkInDate = date("d-m-Y", strtotime($request->start_date));
$checkOutDate = date("d-m-Y", strtotime($request->end_date));

$availableRooms = $this->_availablerooms->from('availableRoom as r')
    ->selectRaw('*,r.roomDoorNum, r.isAvailable, rt.title as roomType,res.roomReservedID')
    ->join('roomtype as rt','rt.roomTypeID','=','r.roomTypeID')
    ->leftjoin('roomReserved as rr','rr.roomID','=','r.roomID')
    ->leftjoin('reservation as res','res.roomReservedID','=', DB::raw('rr.roomReservedID AND (res.reservationDate BETWEEN '."$checkInDate".' AND ' ."$checkOutDate". ' OR res.expiryDate BETWEEN '."$checkInDate".' AND ' ."$checkOutDate".')' ))
    ->get();

return $availableRooms;