title: Order of WHERE clause is affecting result
body: <p>I have some strange problem with one <code>select</code>. 
  Is it possible that the order in <code>WHERE</code> clause can influence the result? </p>
  
  <p>Here is my select:</p>
  
  <pre>
  select u.userName, u.fullName, g.uuid as groupUuid, g.name as `group`, 
      m.number as module, count(distinct b.uuid) as buildCount, max(b.datetime),
      count(distinct e.buildId) as errorBuildCount, e.id as errorId
      from User u
      inner join GROUP_USER GU on GU.user_id = u.id 
      inner join `Group` g on g.id = GU.group_id 
      inner join Course c on c.id = g.courseId
      left outer join Build b on b.userId = u.id 
      left outer join Module m on m.id = b.moduleId 
      left outer join Error e on e.buildId = b.id
      where <b>c.uuid = 'HMUUcabR1S4GRTIwt3wWxzCO' and g.uuid = 'abcdefghijklmnopqrstuvwz'</b>
      group by u.userName,m.number,c.uuid, g.uuid
      order by g.id asc, u.fullName asc, m.number asc
  </pre>
  
  <p>this will reproduce this result:
  <a href="http://dl.dropbox.com/u/4892450/sqlSelectProblem/select1.PNG" rel="nofollow">http://dl.dropbox.com/u/4892450/sqlSelectProblem/select1.PNG</a></p>
  
  <p>When I use this condition:</p>
  
  <p><code>
  where <b>g.uuid = 'abcdefghijklmnopqrstuvwz' and c.uuid = 'HMUUcabR1S4GRTIwt3wWxzCO'</b>
  </code> (different order) I get a different result (see <code>errorId</code> column):
  <a href="http://dl.dropbox.com/u/4892450/sqlSelectProblem/select2.PNG" rel="nofollow">http://dl.dropbox.com/u/4892450/sqlSelectProblem/select2.PNG</a></p>
  
  <p>Could you please help me? Is the whole select wrong, or can it be a  <code>mysql</code> bug?</p>