SELECT  messenger_message.thread_id,
                            MAX(messenger_message.datetime_post),
                            COUNT(DISTINCT(messenger_message.id)),
                            array_agg(DISTINCT(messenger_thread_participants.user_id))
                      FROM messenger_message, messenger_thread_participants WHERE
                            messenger_message.thread_id IN (
							                  SELECT thread_id
							                  FROM messenger_thread_participants
							                        WHERE user_id = 354
							                         AND is_subscribed = TRUE ) AND
                            messenger_thread_participants.thread_id = messenger_message.thread_id
                            AND messenger_message.datetime_post <= '2016-01-12T21:47:13.441Z'::timestamp
                            AND messenger_message.datetime_post > messenger_thread_participants.datetime_unsubscribe
                      GROUP BY messenger_message.thread_id
                      ORDER BY MAX(messenger_message.datetime_post) DESC
                      LIMIT 10 OFFSET 20;

messenger_thread_participants:
    user = models.ForeignKey(User)
    thread = models.ForeignKey(Thread)
    is_subscribed = models.BooleanField()
    datetime_unsubscribe = models.DateTimeField(db_index=True)

messenger_message:
    text = models.TextField()
    sender = models.ForeignKey(User)
    thread = models.ForeignKey(Thread)
    is_read = models.BooleanField()
    datetime_post = models.DateTimeField(db_index=True)
    is_deleted = models.BooleanField()