[{"_id":ObjectId("5fa919a49bbe481d117506c9"),"isDeleted":0,"productId":31,"references":[{"_id":ObjectId("5fa919a49bbe481d117506ca"),"languageCode":"en","languageId":1,"productId":ObjectId("5fa919a49bbe481d117506ba")},{"_id":ObjectId("5fa91cc7d7d52f1e389dee1f"),"languageCode":"ar","languageId":2,"productId":ObjectId("5fa91cc7d7d52f1e389dee1e")},{"_id":ObjectId("5fa91cc7d7d52f1e389dee1e"),"languageCode":"ar","languageId":2,"productId":ObjectId("5fa91cc7d7d52f1e389dee1d")}],"createdAt":ISODate("2020-11-09T10:27:48.859Z"),"updatedAt":ISODate("2020-11-09T10:27:48.859Z"),"__v":0},{"_id":ObjectId("5f9aab1d8e475489270ebe3a"),"isDeleted":0,"productId":21,"references":[{"_id":ObjectId("5f9aab1d8e475489270ebe3b"),"languageCode":"en","languageId":1,"productId":ObjectId("5f9aab1c8e475489270ebe2d")},{"_id":ObjectId("5fa91cc7d7d52f1e389dee1e"),"languageCode":"ar","languageId":2,"productId":ObjectId("5fa91cc7d7d52f1e389dee1d")}],"createdAt":ISODate("2020-10-29T11:44:29.852Z"),"updatedAt":ISODate("2020-10-29T11:44:29.852Z"),"__v":0}]

db.collection.aggregate([{$facet:{arAarray:[{$match:{"references.languageCode":"ar"}},{$unwind:"$references"},{$match:{"references.languageCode":"ar"}},{$group:{_id:"$_id",productId:{$addToSet:"$references.productId"}}}],enArray:[{$match:{$and:[{"references.languageCode":"en"},{"references.languageCode":{$ne:"ar"}}]}},{$unwind:"$references"},{$group:{_id:"$_id",productId:{$addToSet:"$references.productId"}}}]}},{$project:{combined:{"$concatArrays":["$arAarray","$enArray"]}}},{$unwind:"$combined"},{"$replaceRoot":{"newRoot":"$combined"}}])