join_locations scope