title: Multiple conditions in find all
body: <p>i'm tring to enter some conditions in a find('all' on cake. that's my logic:</p>
  
  <pre><code>Traduction.traductions = my username AND Traduction.status = 1 OR 8    
  OR,   Traduction.check1 = my username AND Traduction.status = 5 OR 2     
  OR,   Traduction.check2 = my username AND Traduction.status = 6 OR 3    
  Or,    Trauduction.editions = my username AND Traduction.status = 7 OR 3
  </code></pre>
  
  <p>If one of these condition is right, he display content </p>
  
  <p>that's my code so far</p>
  
  <pre><code>    $conditions = array(
                  'AND' =&gt; array(
                      array(
                          'OR' =&gt; array(
                              array('Traduction.traductions' =&gt; $this-&gt;Session-&gt;read('Auth.User.username')),
                              array('Traduction.status' =&gt; '1'),
                              array('Traduction.status' =&gt; '8')
                          )
                      ),
                  'AND' =&gt; array(
                      array(
                          'OR' =&gt; array(
                              array('Traduction.check1' =&gt; $this-&gt;Session-&gt;read('Auth.User.username')),
                              array('Traduction.check1' =&gt; '5'),
                              array('Traduction.check1' =&gt; '2')
                          )
                      )                       
                  ),
                  'AND' =&gt; array(
                      array(
                          'OR' =&gt; array(
                              array('Traduction.check2' =&gt; $this-&gt;Session-&gt;read('Auth.User.username')),
                              array('Traduction.check2' =&gt; '6'),
                              array('Traduction.check2' =&gt; '3')
                          )
                      )                       
                  ),
                  'AND' =&gt; array(
                      array(
                          'OR' =&gt; array(
                              array('Traduction.edition' =&gt; $this-&gt;Session-&gt;read('Auth.User.username')),
                              array('Traduction.edition' =&gt; '7'),
                              array('Traduction.edition' =&gt; '4')
                          )
                      )                       
                  ),
  
              )
      );
      $traduction = $this-&gt;Traduction-&gt;find('all', array(
          'conditions' =&gt; $conditions
  
      ));
  </code></pre>
  
  <p>but sadly it seems don't work. Here de sql dump</p>
  
  <pre><code>SELECT `Traduction`.`id`, `Traduction`.`serie`, `Traduction`.`issue`,    
  `Traduction`.`page`, `Traduction`.`writer`, `Traduction`.`drawer`, 
  `Traduction`.`release`, `Traduction`.`traductions`, `Traduction`.`check1`, 
  `Traduction`.`check2`, `Traduction`.`edition`, `Traduction`.`user_name`, 
  `Traduction`.`content`, `Traduction`.`status` FROM 
  `dcomicstrad`.`traductions` AS 
  `Traduction` WHERE ((((`Traduction`.`traductions` = 'DrWhat') 
  OR (`Traduction`.`status` = 1) 
  OR (`Traduction`.`status` = 8))) 
  AND (((`Traduction`.`edition` = 'DrWhat') 
  OR (`Traduction`.`edition` = '7') 
  OR (`Traduction`.`edition` = '4'))))
  </code></pre>
  
  <p>Someone can please help me i'm a bit lost with all these array X_X </p>