chats = Chat.objects.filter(room_id=OuterRef('room_id'))
ClientRequests.objects.annotate(last_chat=(Subquery(chats.values('date_create')[:1],
                                                     output_field=DateTimeField()))).order_by('last_chat')