[#83544614] create recent_activities view for better performance