[{"_id":{"$oid":"63032cb474bcf5608897a206"},"roommates":[1,5],"user":1,"target":5,"viewed":true,"text":"1","created_at":{"$numberLong":"1661152436"}},{"_id":{"$oid":"63032cba74bcf5608897a207"},"roommates":[1,5],"user":5,"target":1,"viewed":true,"text":"2","created_at":{"$numberLong":"1661152442"}},{"_id":{"$oid":"63032cc074bcf5608897a208"},"roommates":[1,5],"user":1,"target":5,"viewed":true,"text":"3","created_at":{"$numberLong":"1661152448"}},{"_id":{"$oid":"63032cc274bcf5608897a209"},"roommates":[1,5],"user":5,"target":1,"viewed":true,"text":"4","created_at":{"$numberLong":"1661152450"}},{"_id":{"$oid":"63032d89d0fa10bbc048fac4"},"roommates":[1,2],"user":2,"target":1,"viewed":true,"text":"5","created_at":{"$numberLong":"1661152555"}}]

db.collection.aggregate([{"$match":{"roommates":{"$in":[1],"$nin":[]}}},{"$sort":{"created_at":-1},},{"$limit":25},{"$group":{"_id":"$roommates","user":{"$first":"$user"},"target":{"$first":"$target"},"text":{"$first":"$text"},"created_at":{"$first":"$created_at"},"viewed":{"$first":"$viewed"}}}])