Complicated filter/aggregation based on an ID excluding CREARED from REVIEVED alerts

The most performant and scalable way to do this is possibly through a separate entity-centric alert index. Please see this post for further details with respect to a seemingly very similar scenario.