title: Deceptive MySQL Query
body: <p>So I don't consider myself a novice at MySQL but this one has me stumped:</p>
  
  <p>I have a message board and I want to pull a list of all the most recent posts grouped by the Thread ID.</p>
  
  <p>Here's the table:</p>
  
  <pre><code>MB_Posts
  -ID
  -Thread_ID
  -Created_On (timestamp)
  -Creator_User (user_id)
  -Subject
  -Contents
  -Edited (timestamp)
  -Reported
  </code></pre>
  
  <p>I've tried many different things to keep it simple but I would like help from the community on this one.</p>
  
  <p>Just to kick this out there...this one does not work as expected:</p>
  
  <pre><code>SELECT * FROM MB_Posts GROUP BY Thread_ID ORDER BY ID DESC
  </code></pre>
  
  <p><strong>Desired results:</strong></p>
  
  <p>A set of the most recent posts, one per thread ID</p>