db={"items":[{"_id":"BE05332051E0AD282","type_id":"684EB00155D031225",/**Organization or Book or Person*/"name":"Owi Student Union","structure":{"organization_active_status":"Inactive","country":"USA"},"hash":"59E48A8C3F7B20","geometry":{"type":"Point","coordinates":[-85.48172999999997,32.60746000000006]},"geometry_confidence":0.0,"has_geometry":true,"is_node":false,"groupids":["DE05332041E0A4978"]},{"_id":"9E05332051E0AF344","type_id":"BE0532A041E0AC077","name":"Test Book 1",},{"_id":"0E05333051E0A02E7","type_id":"BE0532A041E0AC087","name":"Test Person 1",}],"tuples":[{"_id":"0E05333051E0A02E7","source_id":"BE05332051E0AD282","destination_id":"9E05332051E0AF344","edge_id":"DE05332051E0A3B5B","direction":NumberInt(1),"changed":true},{"_id":"0E05333061E0A02E8","source_id":"BE05332051E0AD282","destination_id":"0E05333051E0A02E7","edge_id":"DE05332051E0A3B5B","direction":NumberInt(1),"changed":true}],"types":[{"_id":"684EB00155D031225","name":"Organization"},{"_id":"BE0532A041E0AC077","name":"Book"},{"_id":"BE0532A041E0AC087","name":"Person"}]}

db.items.aggregate([{"$match":{"type_id":"684EB00155D031225"}},{"$lookup":{from:"tuples",localField:"_id",foreignField:"source_id",as:"tuples"}},{"$lookup":{from:"items",let:{destination_ids:"$tuples.destination_id"},pipeline:[{$match:{$expr:{$in:["$_id","$$destination_ids"]},"type_id":"BE0532A041E0AC077"}}],as:"books"}},{"$lookup":{from:"items",let:{destination_ids:"$tuples.destination_id"},pipeline:[{$match:{$expr:{$in:["$_id","$$destination_ids"]},"type_id":"BE0532A041E0AC087"}}],as:"persons"}},{"$project":{"_id":1,"type_id":1,"name":1,"books":1,"persons":1}}])