title: Yii Condition with multiple AND/ORs - Operator Precedence
body: <p>What needs to be modified here to get a working select statement?</p>
  
  <p><strong>UPDATED</strong> in regards to Jon's response.</p>
  
  <pre><code>&lt;?php echo $form-&gt;dropDownList($model, 'GroupId', GxHtml::listDataEx(Group::model()
                 -&gt;findAll(array(
                      'condition'=&gt;'SC=:stat AND Pri=:pri AND Type=:typ OR Type=:typ2 OR Type=:typ3', 
                      'params'=&gt;array(':stat'=&gt;'A', ':pri'=&gt;'Y', ':typ'=&gt;'A', ':typ2'=&gt;'B', ':typ3'=&gt;'C')),
                      'GroupId', 'Name')); 
  ?&gt;
  </code></pre>
  
  <p>Which yeilds:</p>
  
  <pre><code>system.db.CDbCommand.query
      (SELECT * FROM `group` `t` 
      WHERE SC=:stat AND Pri=:pri AND Type!=:typ 
      OR Type!=:typ2 OR Type!=:typ3. 
      Bound with :stat='A', :pri='Y', :typ='A', :typ2='B', :typ3='C')
  </code></pre>
  
  <p>The problem here is not everything is taken into account.  Can I add Operator Precedence into the Yii code somehow?</p>