gosh, but here are some scopes with joins
wrote a scope to filter clashes with disconnected users, added and tweaked tests, filled in production code