Do you mean putting the subquery in ON for that join? That might work..

I tried, but couldn't find any way to do the join without a subquery and get the correct order for events.