inner joins for activity view and making it pretty