db={"sites":[{_id:"si-site-a",teamId:"te-team-1",name:"Site a"}],"pages":[{_id:"pa-page-a",teamId:"te-team-1",siteId:"si-site-a",name:"Page A",status:"ok"},{_id:"pa-page-b",teamId:"te-team-1",siteId:"si-site-a",name:"Page B",status:"ok"}],"result":[{_id:"re-result-1",pageId:"pa-page-a",siteId:"si-site-a",results:{scores:{performance:0.75,accessibility:0.98,"best-practices":0.93,seo:1,pwa:0.36,"lighthouse-plugin-ecoscore":0.94},stats:{transferSize:876995,co2grams:0.11,pageLoadTime:1722.284}},region:"gb1",timestamp:ISODate("2022-02-05T16:38:35.454Z"),status:"ok"},{_id:"re-result-2",pageId:"pa-page-b",siteId:"si-site-a",results:{scores:{performance:0.3,accessibility:0.8,"best-practices":0.53,seo:0.3,pwa:0.2,"lighthouse-plugin-ecoscore":0.6},stats:{transferSize:876995,co2grams:0.34,pageLoadTime:1722.284}},region:"gb1",timestamp:ISODate("2022-02-05T16:38:35.454Z"),status:"ok"}]}

db.sites.aggregate([{$lookup:{from:"pages",localField:"_id",foreignField:"siteId",as:"pages",pipeline:[{$lookup:{from:"result",localField:"_id",foreignField:"pageId",as:"results",pipeline:[{$match:{timestamp:{$gte:ISODate("2022-01-01"),$lte:ISODate("2022-12-01")},status:"ok"}}]}},]}},])