db={"tags":[{"_id":{"$oid":"60e9b4823509623a1b26ce5e"},"type":"EVENT","display":true,"baseData":{"title":"rock&pop"},"oeTicketID":"1A"}],"markedItems":[{"_id":{"$oid":"60faa8a11866bb3e0577529c"},"markedItemID":{"$oid":"60e9c40549f04c3a33421dcf"},"userID":{"$oid":"60eaa5d9baf0f2001701b641"},"type":"EVENT"},{"_id":{"$oid":"60facc466bb8c1d5b8a8a211"},"markedItemID":{"$oid":"60e9c40549f04c3a33421dcf"},"userID":{"$oid":"60eaa5d9baf0f2001701b641"},"type":"EVENT"}],"events":[{"_id":{"$oid":"60e9c40449f04c3a33421dcb"},"verification":{"public":true,"statusFixed":false,"status":"APPROVED","oeTicketID":"12740750","info":[]},"baseData":{"location":{"geoLocation":{"type":"Point","coordinates":[9.6724508,47.2528362]},"street":"Savigneux-Platz 4","city":"LANDSHUT / ESSENBACH","country":"DE","venue":"ESKARA Kulturarena","venueID":"202943"},"ticket":{"price":43.25,"link":"https://www.oeticket.com/noapp/event/the-12-tenors-eskara-kulturarena-12740750/?affiliate=I90","onSaleDate":{"$date":"2020-02-03T00:00:00Z"}},"tags":[{"$oid":"60e9b4823509623a1b26ce5e"}],"viewed":0,"title":"The 12 Tenors - Live On Tour","description":"Powered by Evential & ÖTicket","cover":"https://www.oeticket.com/obj/media/AT-eventim/teaser/222x222/2017/12-tenors-tickets-2017-medium.jpg","startTime":{"$date":"2022-01-28T19:00:00Z"},"endTime":{"$date":"2022-01-28T19:00:00Z"},"ageRestriction":"16+","socialMediaLinks":[]},"type":"SUBEVENT"},{"_id":{"$oid":"60e9c40449f04c3a33421dca"},"verification":{"public":true,"statusFixed":false,"status":"APPROVED","oeTicketID":"12713726","info":[]},"baseData":{"location":{"geoLocation":{"type":"Point","coordinates":[9.6724508,47.2528362]},"street":"Schlossplatz 1","city":"ASCHAFFENBURG","country":"DE","venue":"Stadthalle am Schloss - Kirchner Saal","venueID":"202976"},"ticket":{"price":43.35,"link":"https://www.oeticket.com/noapp/event/the-12-tenors-stadthalle-am-schloss-kirchner-saal-12713726/?affiliate=I90","onSaleDate":{"$date":"2020-01-22T00:00:00Z"}},"tags":[{"$oid":"60e9b4823509623a1b26ce5e"}],"viewed":0,"title":"The 12 Tenors - Live On Tour","description":"Powered by Evential & ÖTicket","cover":"https://www.oeticket.com/obj/media/AT-eventim/teaser/222x222/2017/12-tenors-tickets-2017-medium.jpg","startTime":{"$date":"2022-01-07T19:00:00Z"},"endTime":{"$date":"2022-01-07T19:00:00Z"},"ageRestriction":"16+","socialMediaLinks":[]},"type":"SUBEVENT"},{"_id":{"$oid":"60e9c40549f04c3a33421dcf"},"verification":{"public":true,"statusFixed":false,"status":"APPROVED","oeTicketID":"1404921","info":[]},"baseData":{"subEvents":[{"$oid":"60e9c40449f04c3a33421dc9"},{"$oid":"60e9c40449f04c3a33421dca"},{"$oid":"60e9c40449f04c3a33421dcb"}],"tags":[{"$oid":"60e9b4823509623a1b26ce5e"}],"viewed":0,"title":"The 12 Tenors","description":"Powered by Evential & ÖTicket","cover":"https://www.oeticket.com/obj/media/AT-eventim/teaser/222x222/2017/12-tenors-tickets-2017-medium.jpg","socialMediaLinks":[]},"type":"MAINEVENT"},{"_id":{"$oid":"60e9c40449f04c3a33421dc9"},"verification":{"public":true,"statusFixed":false,"status":"APPROVED","oeTicketID":"12659103","info":[]},"baseData":{"location":{"geoLocation":{"type":"Point","coordinates":[9.6724508,47.2528362]},"street":"Am Vennehof 1","city":"BORKEN","country":"DE","venue":"Stadthalle Vennehof Borken","venueID":"202994"},"ticket":{"price":41.8,"link":"https://www.oeticket.com/noapp/event/the-12-tenors-stadthalle-vennehof-borken-12659103/?affiliate=I90","onSaleDate":{"$date":"2020-01-08T00:00:00Z"}},"tags":[{"$oid":"60e9b4823509623a1b26ce5e"}],"viewed":0,"title":"The 12 Tenors - Live On Tour","description":"Powered by Evential & ÖTicket","cover":"https://www.oeticket.com/obj/media/AT-eventim/teaser/222x222/2017/12-tenors-tickets-2017-medium.jpg","startTime":{"$date":"2022-01-04T19:00:00Z"},"endTime":{"$date":"2022-01-04T19:00:00Z"},"ageRestriction":"16+","socialMediaLinks":[]},"type":"SUBEVENT"}]}

db.markedItems.aggregate([{$match:{type:"EVENT"}},{$lookup:{from:"events",localField:"markedItemID",foreignField:"_id",as:"marked_event"}},{$unwind:{path:"$marked_event"}},{$lookup:{from:"events",localField:"marked_event.baseData.subEvents",foreignField:"_id",as:"marked_subEvents"}}])