I have a SQL query and I am trying to display only distinct records like one post of each user order by latest post desc. How to do that? I tried group by and it failed.

```
SELECT jca.id,
ju.name,
jca.actor,
jca.title as title,
jca.created as postedDate
FROM community_activities jca 
left join users ju on jca.actor=ju.id
left join community_users jcu on jcu.userid=ju.id 
ORDER BY jca.id, jca.postedDate DESC LIMIT 0 , 50;

id  name    actor   title   
200     chandra 12      hello man
201     chandra 12      hey man
202     shayam  13      hello hero
203     chandra 12      hello yoyo
204     kokila  16      yep
205     chandra 12      hello y
206     chandra 12      hello  abc

```