Requête Sql pour afficher des loggings distincts

J'ai une requête SQL et j'essaie d'afficher seulement des loggings distincts comme un message de chaque command d'user par le dernier post desc. Comment faire ça? J'ai essayé le groupe par et il a échoué.

SELECT jca.id, ju.name, jca.actor, jca.title as title, jca.created as postdDate 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.postdDate 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 

Pour afficher uniquement la dernière publication de chaque user, créez une table dérivée qui ne contient que le dernier identifiant de chaque user et joignez les activités de community_activities à cette table, afin que seuls ces résultats soient affichés.

 SELECT jca.id, ju.name, jca.actor, jca.title as title, jca.created as postdDate FROM community_activities jca JOIN (SELECT MAX(id) max_id FROM community_activities GROUP BY actor) t1 on t1.max_id = jca.id LEFT JOIN users ju on jca.actor=ju.id LEFT JOIN community_users jcu on jcu.userid=ju.id ORDER BY jca.id, jca.postdDate DESC LIMIT 0 , 50; 
 SELECT MAX(jca.id), -- just selects maximum of each column , DISTINCT ju.name, -- max() may be wrong for your scenario . MAX(jca.actor), MAX(jca.title) as title, MAX(jca.created) as postdDate FROM community_activities jca left join users ju on jca.actor=ju.id left join community_users jcu on jcu.userid=ju.id GROUP BY ju.name; 

sortie:

 202 shayam 13 hello hero 204 kokila 16 yep 206 chandra 12 hello abc 
 SELECT jca.id, ju.name, jca.actor, jca.title AS title, MAX(jca.created) AS postdDate 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.created DESC