Use database joins in transaction view

@todo: this is still too slow!