title: mysql: select max(score) doesn't return the relevant row data
body: <p>if i have for example a scores table:</p>
  
  <pre>
      user game score timestamp
      1    50   50    date
      2    60   40    date
      3    70   25    date
      4    80   18    date
  </pre>
  
  <p>and i run the query:</p>
  
  <pre><code>select user, game, max(score), timestamp from scores
  </code></pre>
  
  <p>i will receive the maximum score number that is 20, but the rest of the columns that are returned are not from that same row.</p>