SELECT

COUNT(*) as counter,

#_social_stream.id,

#_social_stream.actor_id,

#_social_stream.alias,

#_social_stream.actor_type,

#_social_stream.created,

#_social_stream.modified,

#_social_stream.edited,

#_social_stream.title,

#_social_stream.content,

#_social_stream.context_type,

#_social_likes.id,

#_social_likes.type,

#_social_likes.uid,

#_social_likes.stream_id,

#_social_likes.created_by,

#_social_likes.created

FROM

#_social_stream

LEFT JOIN #_social_likes ON #_social_likes.stream_id = #_social_stream.id

WHERE

#_social_stream.created > DATE_SUB( NOW(), INTERVAL 168 HOUR)

GROUP BY

#_social_stream.id

ORDER BY

counter DESC

LIMIT 5