/*SELECT e, c, u, g, MAX(e.createdAt) m FROM KatushkinNewsfeedBundle:Event e
																JOIN e.eventGroup g
																JOIN e.channels c
																JOIN c.subscribers s
																JOIN e.author u
															WHERE e.isDisabled = 0 AND s.user = ?0 GROUP BY e.eventGroup ORDER BY m DESC")*/
  SELECT *, MAX(e.created_at) as m from newsfeed_event e
            JOIN newsfeed_event_group g ON e.event_group_id = g.id
            JOIN newsfeed_event_to_channels ec ON ec.event_id = e.id
            JOIN newsfeed_channel c ON c.id = ec.channel_id
            JOIN newsfeed_channel_to_users s ON s.channel_id = c.id
            JOIN `User` u ON u.User_ID = s.user_id
    WHERE e.is_disabled = 0 AND s.user_id = 1 GROUP BY e.event_group_id ORDER BY e.created_at;