Database
db={"tracks":[],"users":[{"_id":ObjectId("616c80793235ab5cc26dbaff"),"email":"daniel@gmail.com","username":"daniel","password":"$2a$10$2OnHxnyKNdI2RMwJfPCLbO5Sz5uZVSpEqH4x5TUO/wqfBGYFWVkmO","gender":"M","profileImg":null,"socialLinks":{"youtube":null,"soundcloud":null,"instagram":null,"facebook":null,"tiktok":null,"spotify":null},"tracks":[],"isAdmin":false,"downloads":[]}],}
Query
db.users.aggregate([{$match:{_id:ObjectId("616c80793235ab5cc26dbaff")},},{$lookup:{from:"tracks",localField:"tracks",foreignField:"_id",as:"tracks"}},{$unwind:{path:"$tracks",preserveNullAndEmptyArrays:true},},{$group:{_id:ObjectId("616c80793235ab5cc26dbaff"),username:{$first:"$username"},profileImg:{$first:"$profileImg"},socialLinks:{$first:"$socialLinks"},tracks:{$push:{$cond:[{$and:[{$gt:["$tracks.plays",0]},{$gt:["$tracks.downloads",0]},]},{_id:"$tracks._id",name:"$tracks.name",categoryId:"$tracks.categoryId",links:"$tracks.links",mediaId:"$tracks.mediaId",thumbnailId:"$tracks.thumbnailId",plays2:{},plays:"$tracks.plays",downloads:"$tracks.downloads",uploadedDate:"$tracks.uploadedDate"},"$$REMOVE"]}}}}])