Simulate db joins for alerts