Mongo Playground

Configuration

[{"title":"story1_first","isoDate":ISODate("2022-01-01T00:00:00.000Z"),"links":["www.first.com/article1","www.anotherdomain.com"]},{"title":"story1_mention","isoDate":ISODate("2022-01-10T00:00:00.000Z"),"links":["www.first.com/article1","www.somesite.com"]},{"title":"story2_first","isoDate":ISODate("2022-01-20T00:00:00.000Z"),"links":["www.newstory.com/article2","www.anothercompany.com"]},{"title":"story2_mention","isoDate":ISODate("2022-01-20T00:00:00.000Z"),"links":["www.newstory.com/article2","www.anothercompany.com"]}]

Query

db.collection.aggregate([{"$unwind":"$links"},{$sort:{isoDate:1}},{$group:{_id:"$links",first:{$first:"$title"},count:{$sum:1}}},{$match:{count:{$gt:1}}},{$group:{_id:"$first"}},{"$lookup":{"from":"collection","localField":"_id","foreignField":"title","as":"rawDocument"}},{"$unwind":"$rawDocument"},{"$replaceRoot":{"newRoot":"$rawDocument"}}])

Result