title: GROUP BY causes ORDER BY not to work
body: <p>This is my SQL;</p>
  
  <pre><code>SELECT
      cs.name,
      ct.name AS type,
      cr.date,
      cr.hg_version,
      cr.public,
      cr.tag,
      cr.reference,
      cr.description
  FROM changelog_systems cs
  LEFT JOIN changelog_rows cr ON cr.changelog_system_id = cs.id
  LEFT JOIN changelog_types ct ON ct.id = cr.type_id
  GROUP BY name
  ORDER BY cr.date ASC
  </code></pre>
  
  <p>The problem is that I'm not getting my systems with their latest date; instead it just gets the last row that survives the <code>GROUP BY</code>.</p>