added application; group_by + join