CSPACE-5943: Remove an extraneous JOIN, per Ray's candidate query #6 on CSPACE-5945.