This is done better as a map join imo, may even end up shorter.