db={"chat":[{"id":"4hWsHam3ZZpoyIw44q3D","title":"Chat example","create-date":1674476855918,"participants":["63ce54460aeee5e72c778d90","63ce54460aeee5e72c778d92"],"owner_id":"63ce54460aeee5e72c778d90","last_message":null,"unread":5},{"id":"Anjrr9RCWFzq030Cwz7S","title":"New chat One","create-date":1674476909054,"participants":["63ce54460aeee5e72c778d90","63ce54460aeee5e72c778d96"],"owner_id":"63ce54460aeee5e72c778d90","last_message":null,"unread":1}],message:[{"id":"tzwekCiCLSXJ4tfdQuHH","chat_id":"4hWsHam3ZZpoyIw44q3D","from_id":"63ce54460aeee5e72c778d92","create_date":1674557062031,"body":"text","update_at":0,"viewed":false},{"id":"7YqhhS1-EfMRSZtGCH0Z","chat_id":"Anjrr9RCWFzq030Cwz7S","from_id":"63ce54460aeee5e72c778d96","create_date":1674575017115,"body":"text","update_at":0,}],chatsusers:[{"id":"84NNsbZIoJdXSIBqjygj","chat_id":"4hWsHam3ZZpoyIw44q3D","user_id":"63ce54460aeee5e72c778d92","start_message_id":0,},{"id":"xL_Ozkpg8LrjbsNqplmj","chat_id":"Anjrr9RCWFzq030Cwz7S","user_id":"63ce54460aeee5e72c778d96","start_message_id":1674654898775,},]}

db.chat.aggregate([{$match:{participants:"63ce54460aeee5e72c778d90",}},{$lookup:{from:"chatsusers",localField:"id",foreignField:"chat_id",as:"chat_user",},},{$unwind:{path:"$chat_user",}},{$lookup:{from:"message",localField:"id",foreignField:"chat_id",pipeline:[{$match:{$expr:{$gte:["$last_message.create_date","$chat_user.start_message_id"]},},},{$sort:{create_date:-1}},{$limit:1},],as:"last_message",}},{$unwind:{path:"$last_message",preserveNullAndEmptyArrays:true}},{$project:{id:1,title:1,create_date:1,type:1,participants:1,owner_id:1,price:1,last_message:"$last_message",unread:1,}}])