title: ORDER BY not working as expected with GROUP BY
body: <p>I have two tables, establishment and branch. Establishment is the parent table. When I select a list of branches, I want it to retrieve the establishment name if the branch title is blank. Also, I only want to show a branch once for each establishment. This is what I came up with:</p>
  
  <pre><code>SELECT 
    branch.id
    , branch.establishment_ID
    , IFNULL(branch.branch_title, establishment.name) AS branch_title 
  FROM branch 
  LEFT JOIN establishment ON branch.establishment_ID = establishment.id 
  WHERE cityID = 2 
  GROUP BY establishment_ID 
  ORDER BY branch_title
  </code></pre>
  
  <p>However, the results do not appear to be in any particular order. I want them to be in alphabetical order. I've read that MySQL 5.0.5 had problems with GROUP BY and ORDER BY in the same query, but I'm working with 5.5.9. What can I do to fix this query?</p>