db={task:[{fields:{client:[{uuid:"b5050bf2-ca75-4b0a-920c-628ca45f929a"}],uuid:"35c0541d-dd39-420b-9f74-027a9a268f88"}}],client:[{updated_at:ISODate("2024-03-18T12:07:17.313Z"),fields:{uuid:"b5050bf2-ca75-4b0a-920c-628ca45f929a"}}]}

db.task.aggregate([{"$sort":{"updated_at":-1}},{"$group":{"_id":"$fields.uuid","doc":{"$first":"$$ROOT"}}},{"$replaceRoot":{"newRoot":"$doc"}},{"$match":{"fields.uuid":{"$in":["35c0541d-dd39-420b-9f74-027a9a268f88"]}}},{"$lookup":{"from":"client","let":{"client_uuid":"$fields.client.uuid"},"pipeline":[{"$match":{"$expr":{"$in":["$fields.uuid","$$client_uuid"]}}},{"$sort":{"updated_at":-1}},{"$limit":1}],"as":"related_client"}}])