I have two DB tables, one that store events and the second that stores any associated comments for that event.

DB Tables:

```
events: id, owner_id, timestamp
comments: cmt_id, parent_id(events id), cmt_time

```

I'm trying to get the last 5 comments for each event based on a specific owner\_id.

This is how I'm joining my tables:

```
SELECT * FROM `events` 
LEFT JOIN comments ON comments.parent_id=events.id 
WHERE owner_id=X     
ORDER BY timestamp DESC LIMIT 0,5

```

Any idea how I can get the number of comments based on the event\_id?