title: Kohana Query Builder: and or where clause
body: <pre><code>            -&gt;where('orders.date_paid', 'BETWEEN', array($from, $to))
              -&gt;and_where('orders.status', '=', 'new')
              -&gt;or_where('orders.status', '=', 'delivered')
  </code></pre>
  
  <p>I would like to show all rows where date_paid is between $from and $to, where status is either new or delivered.</p>
  
  <p>When i add this or_where(), it ignores the BETWEEN $from and $to date_paid where clause. </p>
  
  <p>How can i do this right?</p>