title: How to get the latest message in each conversation of a certain user in SQL?
body: <p>I need to write a query that returns the latest message in a conversation between two users. I've included the schema and my (failed) attempts in this fiddle: <a href="http://sqlfiddle.com/#!15/322c3/11" rel="nofollow">http://sqlfiddle.com/#!15/322c3/11</a></p>
  
  <p>I've been working around the problem for some time now but every time I run any of my ugly queries <em>a sweet little kitten dies</em>.</p>
  
  <p>Any help would be much appreciated. Do it for the <em>kittens</em>.</p>