db={products:[{"_id":ObjectId("5808d700536d1a3d69f4cf51"),result:{"template":["Mcd","ded","GCD"]},"likes":[ObjectId("5808d700536d1a3d69f4cf21"),ObjectId("5808d700536d1a3d69f4cf22")],"view":3,dataB:true},{"_id":ObjectId("5808d700536d1a3d69f4cf53"),result:{"template":["CCD","GHG"]},"likes":[ObjectId("5808d700536d1a3d69f4cf31"),ObjectId("5808d700536d1a3d69f4cf32")],"view":6,},{"_id":ObjectId("5808d700536d1a3d69f4cf57"),result:{"template":["VVD","SSD","Fsd","Xcd",]},"likes":[ObjectId("5808d700536d1a3d69f4cf24"),ObjectId("5808d700536d1a3d69f4cf25"),ObjectId("5808d700536d1a3d69f4cf26")],"view":6,}],orders:[{"_id":ObjectId("5808d700536d1a3d69f4df91"),"price":251,"qty":3,"product_id":ObjectId("5808d700536d1a3d69f4cf57"),dataB:true},{"_id":ObjectId("5808d700536d1a3d69f1cf93"),"price":175,"qty":2,"product_id":ObjectId("5808d700536d1a3d69f4cf51"),},{"_id":ObjectId("5808d700536d1a3d59f4cf97"),"price":150,"qty":1,"product_id":ObjectId("5808d700536d1a3d69f4cf51"),}]}

db.products.aggregate([{"$lookup":{"from":"orders","localField":"_id","foreignField":"product_id","as":"orders"}},{"$project":{"likes":1,"orderCount":{"$size":{"$cond":{"if":{"$isArray":["$orders"]},"then":"$orders","else":[]}}},"likeCount":{"$size":{"$cond":{"if":{"$isArray":["$likes"]},"then":"$likes","else":[]}}},"views":{"$ifNull":["$view",0]}}},{"$group":{"_id":"$_id","totalSum":{$sum:{"$add":["$likeCount","$orderCount","$views"]}},"like":{"$first":"$likes"}}},{"$sort":{"totalSum":-1}}])