Help adding DISTINCT to query

[slj90]

I need to add likes_username to this query and use a DISTINCT on it.

 

It currently counts how many likes a status has but in the table there are some statuses with multiple likes from the same username. 

SELECT s.*, COUNT(l.likes_location_id) AS likeCount
 FROM stream AS s
  LEFT JOIN likes AS l ON ( l.likes_location_id = s.stream_id )
 GROUP BY s.stream_id
 ORDER BY s.stream_id DESC LIMIT 50

Many thanks,

 

[Barand]

You could add

COUNT(DISTINCT l.likes_username) as userCount

to the select clause

[Psycho]

 

 

. . . there are some statuses with multiple likes from the same username.

 

Sounds like you are trying to solve the wrong problem. Why are you allowing the same user to "like" the same status multiple times?