join project refactored to work in views testing environment