title: Counting records from another mysql table with a left join
body: <p>I have two DB tables, one that store events and the second that stores any associated comments for that event.</p>
  
  <p>DB Tables:</p>
  
  <pre><code>events: id, owner_id, timestamp
  comments: cmt_id, parent_id(events id), cmt_time
  </code></pre>
  
  <p>I'm trying to get the last 5 comments for each event based on a specific owner_id.</p>
  
  <p>This is how I'm joining my tables:</p>
  
  <pre><code>SELECT * FROM `events` 
  LEFT JOIN comments ON comments.parent_id=events.id 
  WHERE owner_id=X     
  ORDER BY timestamp DESC LIMIT 0,5
  </code></pre>
  
  <p>Any idea how I can get the number of comments based on the event_id?</p>