title: Laravel 4 - Join table but only latest row
body: <p>I have 2 tables : Quotes, Responses.</p>
  
  <p>In a datatable , I show quotes, and for each row, I show a column count of responses. I want now to show date of latest response, but I'm blocked :(</p>
  
  <p>Here is my code:</p>
  
  <pre><code>$quotes = Quote::select('Quotes.*', DB::raw('COUNT(Responses.id) as total_responses') )
      -&gt;leftjoin('Responses', function($join)
      {
          $join-&gt;on('Responses.quote_id', '=', 'Quotes.id')
          -&gt;where('Responses.state', '!=', '0');
      })
      -&gt;groupby('Quotes.id');
  </code></pre>
  
  <p>Is it possible to add another left join with same table, with custom query to select only latest row?</p>
  
  <p>Thanks for helping</p>