title: Laravel query Or operator priority
body: <p>I am using laravel 4 query. I want get data by OR condition. Is there any priority rule with Laravel 4 ?</p>
  
  <p>My Query is :</p>
  
  <pre><code>SELECT * 
  FROM order_items 
  WHERE (status = 'Y' OR (status = 'N' AND amount &gt; 100)) 
  AND product_id = '15' 
  LIMIT 1;
  </code></pre>
  
  <p>I have 2 order items but i want the first item in the result will get the prority status = 'Y', if its not there, then it meet the second condition of OR. </p>
  
  <p>Here is my laravel code :</p>
  
  <pre><code>$sql_select = "SELECT * 
                 FROM order_items 
                  WHERE (status = 'Y' OR (status = 'N' AND amount &gt; 100)) 
                  AND product_id = '15' 
                  LIMIT 1";
  $data = DB::select($sql_select);
  echo "&lt;pre&gt;";
  print_r($data);
  die;
  </code></pre>
  
  <p>For simple mysql query, its working, but in laravel its not giving results.</p>